Filter Request: "Is NOT in the last"

Feature requests
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.

2

I really want this ability as well. When used with the “Last updated” field, it will identify items that have fallen through the cracks.

Another solution would be to allow negative numbers in the “in the last” number box.

Thanks,
Eric

3

You can easly apply the following set of filters to achieve that goal:

image
image675×302 21.8 KB

I hope this works

4

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.

  1. Create a new formula column
  2. Set the formula to ADD_DAYS({date field}, 30) < TODAY() (or something similar)
  3. In your filter, check if the formula field “is” “true”
5

Hi @shirozayas, thank you for posting the idea!

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.

Thanks again!

6

+1 How come this is still not done?