Sharepoint 2010 Content Type Hub – New calculated column not propogating to children

Published on

Had a weird problem where I was updating a master content type, adding a calculated column to it which I wanted to propogate down to all content types inheriting from the master but no matter what the new calculated column never appeared. It turned out that the logic & syntax in my calculated column didnt … Continue reading Sharepoint 2010 Content Type Hub – New calculated column not propogating to children

Sharepoint calculated column more date / day calculations

Published on

Avoiding Saturday & Sundays if you were sending out alerts for example: =IF([Call due day]=”Saturday”,[Call due date]+2,IF([Call due day]=”Sunday”,[Call due date]+2,[Call due date]) Displaying the day as text: =TEXT(WEEKDAY([Due Date]),”dddd”) Say you have a date in US format and you want to convert it to UK format: =TEXT([Your Date Field],”DD-MM-YYYY”)

Sharepoint Calculated Column – Tasks Due This Week

Published on

To show tasks due this week, create the following 2 calculated columns: Week start (Monday) =[due date]-(WEEKDAY([due date],2)-1) Week end (Friday) =[due date]+(5–WEEKDAY([due date],2)) Create a view where: Week start is less than or equal to [Today] AND Week end is greater than or equal to [Today] More useful scenarios here: http://www.myriadtech.com.au/blog/Alana/Lists/Posts/Post.aspx?ID=8

Using a calculated column to display month name

Published on

You probably think this is going to be quite long winded & involve many IF statements, its actually pretty simple as I just found out. Create a ‘Calculated Column’ & for your formula add: =TEXT([YourDateField],”mmmm”)