Status Report based on certain conditions, i.e. dates, status etc
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!!!
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
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.