Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Using Report builder to find past due 'Days' tasks
I have a sheet that lists bugs and it has a 'Created Date' column (not a system column, just a date column). I need to generate a report of all issues that are 'Open' Β and 30 days old. I can check for 'Open'. But I wasn't able to find a way to check for 30 days old in the report builder. Can I do this just using the report builder without adding addtional columns to the sheet? Something like'todays date'-created date >30 under the 'When' criteria in Report Builder?
Comments
-
This should be possible.
In the Report Builder, select the "When?" button to select the date column of interest.
Once selected, you can set the criteria. I assume you mean "older than 30 days"
so use three choices:
(in the last 30 days) or (today) or (in the future)
and then click the exclude checkbox.
Β
And your check for ''Open" and Bob's your uncle.
Β
Craig
-
Urgh! I had missed the all powerfull 'Exclude' check box. Thanks Craig!!
Β
-
Definitely worth while.
There's a few complex conditions that won't work in the Report Builder, but many can be.
Β
Craig
