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: Created a calculated field in a SharePoint list/library to split a filepath and store the first 3 folder levels in 3 separate metadata fields. ...
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 ...
Thanks for the formula. It worked for me