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.
Reporting on the current week
I would like to create a report that would show what needs to be focused on in the current week and I am defining "what" according as follows:
1) Each group of projects (smartsheets) should be bundled into a report; one report for the entire program of projects. Each group has its own report.
2) The individual tasks are identified as follows:
- Any task starting or ending in the next X days (I like "5") AND Complete < 100%
- Any task that has a start date in the past and complete is 0%
- Any task that has an end date in the past and complete is less than 100%
I currently think this is beyond the capability of the Report Builder but as I am somewhat new to Smartsheets, I thought I would check with the brain trust.
Thanks,
AEG
Comments
-
Does this help?
-
This is all possible to do, you just cant have all that critria in the same report without a workaround.
What you can do, is add a checkbox column to your sheets with a formula that checks the box when your conditions are met (end date in the past and % < 100) then use the checkbox column as a criteria in your report.
