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

Andrew Gross
Andrew Gross ✭✭✭✭
edited 12/09/19 in Archived 2015 Posts

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.  







This discussion has been closed.