Post

2 followers Follow
0
Avatar

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 Answered

Please sign in to leave a comment.

2 comments

0
Avatar

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 0 votes
Comment actions Permalink