Sign in to join the conversation:
Is there a way to create a report that queries a sheet and shows any rows that haven't been modified in the last 30 days?
Hi Stephanie,
Yes, it is! You'd add the Modified Column and is in the last 30 day(s) in the When section.
Did it work?
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
What about creating a report that shows if a column has NOT been modified in the last 30 days?
When adding the condition of when the date is within the past 30 days, there is a checkbox at the bottom of the criteria window that you can check to exclude rows that meet that specific criteria and show everything else.
I missed adding the NOT.
No worries. I do it to myself all the time.
How can I delete old sheets I no longer use from my account?
I'm trying to display a task progress chart showing "complete", "late", and "not complete" in my dashboard and for some reason the chart will display as a column chart but it won't display as a donut chart even though I'm referencing the same report. I'd prefer to display as a donut chart as I think it looks better and is…
Hello, I am trying to create a chart widget in my dashboard, but I keep getting "Selected data cannot be charted. Please select a new range." error. The report I am using is already summarized in numeric value. What is funny is I have report that I created a chart widget in another dashboard, and when I use that same…
