Requirement
Create a calculated column called ‘Progress Report No’ based on the following format:
yyyy.MM.W(WeekOfMonth).
e.g. A report created on 4/8/2011 would be, 2011.8.W1
Solution
The formula for the calculated column is:
=TEXT(Created,”yyyy”)&”.”&MONTH(Created)&”.W”&ROUND((DATEDIF(DATE(YEAR(Created),MONTH(Created),1)-(WEEKDAY(DATE(YEAR(Created),MONTH(Created),1),1))+1,Created+(7-WEEKDAY(Created,2)),”D”)+1)/7,0)
Requirement Generate a list of SCAs across all your SharePoint site collections. Solution function Get-SCA { param($site) $link = $site+"/_layouts/mngsiteadmin.aspx" $result = Invoke-WebRequest $link ...
Requirement Download all versions of a file in SharePoint to a local folder on your computer. Solution Use the PowerShell script below to do this. ...
Problem: Before Service Pack 2, you could specify an e-mail address in the cc’ field of a workflow form. After installing Service Pack 2, this ...
Problem: We have some scripts that use jQuery Library for SharePoint Web Services. After installing Service Pack 2 for SharePoint 2010, several of the scripts ...
Requirement Calculated columns by default appear on all out of the box display forms due to the fact that they are ‘optional’ when applied to ...
Thanks for the formula. It worked for me