Using a Negative Filter

I am trying to create a report that will show all projects NOT updated within the last 30 days. I do not want to enter hard dates in the report as this would create the need to adjust the dates monthly. Is there a way to set this up without hard dates?

Thanks in Advance!!

Karen Hopson January 16, 2020 17:05 Answered

Please sign in to leave a comment.

2 comments
Date Votes

Hello Karen,

It's possible using a formula column. Steps:

1) Add a formula column in your report:

2) Filter using that column (Recently updated = FALSE).

I hope this helps.

Roland

Roland Pumputis January 24, 2020 07:23 0 votes

Fantastic Roland! Thank you very much!!

Karen Hopson January 24, 2020 12:34 0 votes

Using a Negative Filter

2 comments Date Votes

2 comments
Date Votes