Status Report based on certain conditions, i.e. dates, status etc

Thiago Castro
Thiago Castro ✭✭✭✭
edited 12/09/19 in Formulas and Functions

Hi Smartsheet community, 

I'm trying to come up with a status report to display information on what has been done in our projects between certain dates. I would really appreciate your expertise and help!!!

For example:

Project A Status Report for the period 04/Nov/19 - 17/Nov/19

What I want to show is:

1. Completed Deliverables (Phase/Milestone/Task) in the period mentioned above

2. Incompleted Deliverables (Phase/Milestone/Task) that had its End date set for >= 04/Nov/19 and <=17/Nov/19 which did not have it's % Completed = 100%

3. Planned Deliverables for the next Status Report Period (Phase/Milestone/Task) that had its End date set for >= 18/Nov/19 and <=1/Dec/19 which currently its % Completed isn't set as 100% Completed

Note:

I have a Cell where I can put "Status Report Start Date and another End Date" also can create another 2 Cell to show Next Period, which means if I want to report for the full month or just a week I can adjust the dates accordingly.

Any suggestion?

 

 

Status Report by Period.png

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!