Reporting on the current week

Andrew Gross

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

 

APJ Enablement

Does this help?

Sam S

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.