Use case: I have a list of rows in a table. Each row has a:
- LastUpdated field in that table (“Last modified” data type) - indicating when the row was last updated/commented
- a ‘tag’ field (single choice) indicating whether it’s “open” (pending) or “closed” (completed)
Stale rows are defined as rows that were last updated more than six months ago and are still “open”. I want a view to list all the stale issues in that table.
Feature request: For the above, I need a filter such as “LastUpdated → is older than X months → six months ago”.
We already have “is months ago” (which only gives an exact match) and “is before date” (which only accepts static dates). So I need a combination of them both → “is before X months ago”.