hi hi.. recently start work on Sharepoint admin area also, so now want to share about the simple formulas in calculated columns. At the custom list you can add in one new column with calculated type, then can use simple formula to pull data from othe column and do some calculation .
Below is the simple formula for IF :
=IF(Column1<=Column2, "OK", "Not OK")
However using the function like that causes a syntax-error.
The correct syntax is
=IF(Column1<=Column2; "OK"; "Not OK")
Date and time, Financial, Information, Logical, Lookup and reference, Math and trigonometry, Statistical,Text and data
http://office.microsoft.com/en-us/sharepointtechnology/CH100650061033.aspx
http://office.microsoft.com/en-us/sharepointtechnology/HA011609471033.aspx
keep track and sharing on my sharepoint knowledge :) nice to meet you all
which country user step here?
Tag Cloud
MOSS
(47)
SharePoint 2007
(37)
SharePoint 2013
(31)
SharePoint 2010
(23)
MOSS admin
(17)
PowerShell
(17)
admin
(17)
developer
(16)
List
(15)
WSS
(14)
sql query
(14)
MOSS SP2
(13)
end user
(11)
scripting
(11)
wss V3
(11)
permission
(10)
sql
(9)
Moss issue
(8)
search
(8)
database
(7)
RBS
(6)
Service Pack
(6)
reportadmin
(6)
workflow
(6)
CU
(5)
Excel
(5)
Patch
(5)
client object model
(5)
Client Code
(4)
Command
(4)
Cumulative Updates
(4)
IIS
(4)
SharePoint 2019
(4)
SharePoint designer
(4)
office 365
(4)
stsadm
(4)
user porfile
(4)
ASP.NET
(3)
Content Database
(3)
Groove
(3)
Host Named Site Collections (HNSC)
(3)
SharePoint 2016
(3)
Tutorial
(3)
alert
(3)
authentication
(3)
batch file
(3)
codeplex
(3)
domain
(3)
error
(3)
incomming email
(3)
issue
(3)
restore
(3)
upload
(3)
Caching
(2)
DocAve 6
(2)
Folder
(2)
Index
(2)
Internet
(2)
My Site Cleanup Job
(2)
My Sites
(2)
News
(2)
People Picker
(2)
Share Document
(2)
SharePoint admin
(2)
View
(2)
Web Development with ASP.NET
(2)
add user
(2)
audit
(2)
coding
(2)
column
(2)
deploy solution
(2)
download
(2)
enumsites
(2)
exam
(2)
export
(2)
june CU
(2)
load balance
(2)
mySites
(2)
network
(2)
orphan site
(2)
performance
(2)
profile
(2)
project server
(2)
query
(2)
security
(2)
server admin
(2)
theme
(2)
timer job
(2)
training
(2)
web master
(2)
web.config
(2)
wsp
(2)
70-346
(1)
70-630
(1)
AAM
(1)
Anonymous
(1)
Approval
(1)
AvePoint
(1)
Cerificate
(1)
Consultants
(1)
Content Deployment
(1)
Content Type
(1)
DOS
(1)
Document Library
(1)
Drive Sapce
(1)
Excel Services
(1)
Export to Excel
(1)
Feature
(1)
GAC
(1)
Get-SPContentDatabase
(1)
Get-WmiObject
(1)
HTML calculated column
(1)
ISA2006
(1)
IT Knowledge
(1)
ITIL
(1)
Install
(1)
Link
(1)
MCTS
(1)
Macro
(1)
Masking
(1)
Migration
(1)
NLBS
(1)
Nintex
(1)
Office
(1)
Open with Explorer
(1)
ROIScan.vbs
(1)
Reporting Services
(1)
SPDisposeCheck.exe
(1)
SQL Instance name
(1)
SSRS
(1)
Sandbox
(1)
SharePoint Online
(1)
SharePoint farm
(1)
Shared Services Administration
(1)
Site Collection Owner
(1)
Site template
(1)
Skype for business
(1)
Steelhead
(1)
Teams
(1)
URLSCAN
(1)
VLOOKUP
(1)
WSS SP2
(1)
XCOPY
(1)
abnormal incident
(1)
admi
(1)
app
(1)
application pool
(1)
aspx
(1)
availabilty
(1)
backup
(1)
binding
(1)
blob
(1)
branding sharepoint
(1)
cache
(1)
calendar
(1)
change password
(1)
connection
(1)
copy file
(1)
counter
(1)
crawl
(1)
custom list
(1)
domain security group
(1)
event
(1)
excel 2013
(1)
facebook
(1)
filter
(1)
fun
(1)
group
(1)
iis log
(1)
import
(1)
import list
(1)
improment
(1)
interview
(1)
keberos
(1)
licensing
(1)
log in
(1)
metada
(1)
migrate
(1)
mossrap
(1)
notepad++
(1)
onedrive for business
(1)
operation
(1)
owa
(1)
process
(1)
publishing feature
(1)
resource
(1)
send email
(1)
size
(1)
sps2003
(1)
sql201
(1)
sql2012
(1)
sub sites
(1)
system
(1)
table
(1)
task list
(1)
today date
(1)
trial
(1)
vbs
(1)
video
(1)
web part
(1)
web server
(1)
widget
(1)
windows 2008
(1)
windows 2012 R2
(1)
windows Azura
(1)
windows account
(1)
windows2012
(1)
wmi
(1)
Sunday, March 28, 2010
Thursday, March 25, 2010
Overview of usage reports
The following usage reports are available:
-
Site usage report Site administrators, including administrators of the Shared Services Administration site, can view usage reporting for their site by clicking Site usage reports in theSite Administration section of the Site Settings page.
-
Site collection usage report Site collection administrators for most site collections can view usage reporting by clicking Site collection usage reports in the Site Collection Administrationsection of the Site Settings page.
-
Site collection usage summary Site collection administrators for the Shared Services Administration site and individuals with personal sites can view the Site Collection Usage Summary page by clicking Usage summary in the Site Collection Administration section of the Site Settings page.
Problem description:
=================
The data in SpUsageWeb.aspx don’t match the data in the UsageDetails.aspx page.
Plan:
==================
The issue is fixed in the April’s Service Pack, which is going to be released. We are now testing the Service Pack and will update you once we finish the test.
If no exception, I will send you the Service Pack early next week. Then you can try and see if the issue can be fixed by the Service Pack.
Additional information:
==================
The _layouts/usagedetails.aspx page is still available in SharePoint 2007, although there is no link to it in the site settings page.
If the Site Usage Report works properly, the data in the usagedetails.aspx should match the data in the SpUsageWeb.aspx.
Tuesday, March 23, 2010
VLOOKUP for you to join table
Just now try to gather all the DB size from DB and SharePoint CA, to join the data from DB and sharepoint at excel i use the VLOOKUP :
From CA Content DBDatabase Name | Database Status | Current Number of Sites | Site Level Warning | Maximum Number of Sites |
Contend_DB1 | Started | 4 | 8 | 10 |
From SQL Query > use this command at SQL query exec sp_databases
DB name | Size | MB | GB |
Contend_DB1 | 165860032 | 161972.69 | 158.1764526 |
Combine the data in one excel sheer : DB size GB with following VLOOKUP
=VLOOKUP(A2(this is the data you want to match), [the rage of the SQL query data],4(which role want to return),FALSE)
Database Name | DB Size GB | Database Status | Current Number of Sites | Site Level Warning | Maximum Number of Sites |
Contend_DB1 | 158.1764526 | Started | 4 | 8 | 10 |
Wednesday, March 17, 2010
Windows SharePoint Services 3.0 Service Pack 1 Retired at 13/07/2010
woo!!! are you already upgrade your sharepoint server up to SP 2? if not please act faster!!! Microsoft going to stop the support for SP1 soon. http://support.microsoft.com/lifecycle/?p1=12200Windows SharePoint Services 3.0 Service Pack 1 Retired at 13/07/2010
I have some blog to share about the SP2 installation step at here, feel free to have a look. or you can just do search over internet than you will see a lot people share on this :) . If you environment not really have a lot customization then you will easy for the upgrade :)
I have some blog to share about the SP2 installation step at here, feel free to have a look. or you can just do search over internet than you will see a lot people share on this :) . If you environment not really have a lot customization then you will easy for the upgrade :)
Subscribe to:
Posts (Atom)