1

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.

1
  • Be aware that the list item will not be hidden from Search unless you change the list item permissions Mar 7, 2019 at 18:41

2 Answers 2

1

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])...

[UPDATE]

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

4
  • 1
    Ok that will work. However, how do I also factor in the 60 days? Mar 7, 2019 at 16:21
  • Just edited the answer to reflect the time factor.
    – DanJ
    Mar 7, 2019 at 16:26
  • Im sorry. I just edited the question to better reflect what i need. Mar 7, 2019 at 16:28
  • 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.
    – DanJ
    Mar 7, 2019 at 16:40
0

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

Reference:

  1. Create, change, or delete a view of a list or library.
  2. Use filtering to modify a SharePoint view.
2
  • Try this and let me know it works for you or not. Mar 7, 2019 at 16:29
  • thank you for your answer; however, i just made an edit to the question to better reflect what I need. Mar 7, 2019 at 16:32

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.