Different type of view in SharePoint document library (Root & Sub Folder)

When we want to have a default view at the root level of the library and different default view for subfolders.
By default, the default view will be applied to the whole document library but when we want to have a different view with its own sorting, filtering, etc. we can use the method below:
Continue reading Different type of view in SharePoint document library (Root & Sub Folder)

How to calculate the reminder date automatically and display the item based on the month & year of its reminder date (Part-2)

Part 2: Steps to display the item based on the month & year of its reminder date

1. ​Create 2 more columns with the steps in Part 1 (Step 1 – 5). Then, named the 2 columns as “​Reminder Start Month” and “Reminder End Month” with the formula:-

​Reminder Start Month (First day) ​Reminder End Month​ (Last day)
​=DATE(YEAR([ReminderDate]),MONTH([Reminder Date]),1) ​=DATE(YEAR([Reminder Date]),MONTH([Reminder Date])+1,1)-1

Continue reading How to calculate the reminder date automatically and display the item based on the month & year of its reminder date (Part-2)

How to calculate the reminder date automatically and display the item based on the month & year of its reminder date (Part-1)

One of our customer required to calculate the item’s reminder date automatically based on the item’s expiry date and display the item that its reminder date is placed on current month & year.

The reminder date will be the date which is 3 months before the expiry date. For example:-

Continue reading How to calculate the reminder date automatically and display the item based on the month & year of its reminder date (Part-1)