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

Find more posts tagged with

Reports

Comments

APJ Enablement

Does this help?

Reports-Toggle And Or.png

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.