FredBaker
(Integrated Human | Authorized Partner)
1
It would be REALLY nice to have some filters for:
Is NOT in the last (for example, give me results where STATUS is NOT in the last 30 days).
One use case is to highlight projects that are older than 30/60/90 days in a dashboard. This would also work well for billing and other items, and it seems like an easy add to flip the value on the “is in the last” filter.
That’s incorrect. I only want the items that have a Last updated date OLDER than the last 30 days. Your filter only includes items that have BEEN updated in the last 30 days. That’s the opposite of our goal.
Here’s a stupid work around if you need this.
Create a new formula column
Set the formula to ADD_DAYS({date field}, 30) < TODAY() (or something similar)
In your filter, check if the formula field “is” “true”
FredBaker
(Integrated Human | Authorized Partner)
5
Your example works for things in the last 30 days, but won’t work if I wanted something like things that were newer than 60 days, but also older than 30 days (so in the last 31-60 days only).
This would also work forward looking, say if I have upcoming dates and want to know what’s in the pipeline 1-30 days, 31-60 days, 61-90 days, etc.
The current workaround solution is to use a formula column to only track if the date is within the 31-60 day and filter by that, but it’s a lot more involved than just having a NOT filter.