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.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 34 Webinars
- 7.3K Forum Archives