Showing posts with label list view. Show all posts
Showing posts with label list view. Show all posts

Friday, 15 September 2017

How to create week wise list views in SharePoint?


To create week wise list view in SharePoint list follow the following steps.

Step 1. Create a calculated column named 'WeekStart' of type Date with the following formula:

=IF(TEXT(WEEKDAY([Created]),"ddd")="Mon",[Created],(IF(TEXT(WEEKDAY([Created]-1),"ddd")="Mon",[Created]-1,(IF(TEXT(WEEKDAY([Created]-2),"ddd")="Mon",[Created]-2,(IF(TEXT(WEEKDAY([Created]-3),"ddd")="Mon",[Created]-3,(IF(TEXT(WEEKDAY([Created]-4),"ddd")="Mon",[Created]-4,(IF(TEXT(WEEKDAY([Created]-5),"ddd")="Mon",[Created]-5,[Created]-6))))))

Step 2. Create a calculated column named 'WeekEnd' of type Date with the following formula:

=IF(TEXT(WEEKDAY([Created]),"ddd")="Sun",[Created],(IF(TEXT(WEEKDAY([Created]+1),"ddd")="Sun",[Created]+1,(IF(TEXT(WEEKDAY([Created]+2),"ddd")="Sun",[Created]+2,(IF(TEXT(WEEKDAY([Created]+3),"ddd")="Sun",[Created]+3,(IF(TEXT(WEEKDAY([Created]+4),"ddd")="Sun",[Created]+4,(IF(TEXT(WEEKDAY([Created]+5),"ddd")="Sun",[Created]+5,[Created]+6))))))


Step 3. Create a new view to filter the items based on the following criteria:

WeekStart < [Today] < WeekEnd.


Following can be used to create a previous week view: WeekStart < [Today]-7 < WeekEnd. Similarly following for next week WeekStart < [Today]+7 < WeekEnd.