I have a SharePoint list. I also have a column called 'Status'.
I want to be able to hide the list item when
Status = closed and 60 days have passed from the point Status is changed.
Please help me.
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It only takes a minute to sign up.Sign up to join this community
One option is to modify your list view:
In your list view, you could set a filter that states "Show the items when column 'Status' is equal to 'Open' (and whatever options you have other than 'Closed').
As far as the time passed issue is concerned, the filter could be set to the Created column as well - something along the lines of when Created is greater than ([today]+60).
Yet another way to approach the time situation is to create a new calculated column that isn't visible in the view that holds the value of the 'Time Passed' column + 60. You can then go to your list view and set the filter for something along the lines of - when NewColumn is less than ([today])...
Based on your revision, the concept for your solution remains the same (somewhat). The new column (as stated in the end of my answer above) would still be a calculated column, but would hold the value of: =IF(Status="Closed",TEXT(NOW(),"dd/mm/yyyy hh:mm"),IF(ISBLANK(Status),"","NULL"))
or something similar. Then have the filter refer just as I stated above
You can achieve this using SharePoint list view filters.
Create a new view or use existing view and add filters:
Status is not equal to Closed. AND Created is greater than or equal to [Today]-60