Project Status Count
Hi. I am creating a project dashboard and would like to know if there is a way to include a count of weeks a project status has been at different levels. I have a sheet for each project and an overall selection for the project status on the sheet. I would like to keep track of how many weeks a project was in each status during the lifecycle of the project. For example, a 2 month project, which is now complete, was in green phase for 6 weeks, and yellow phase for 2 weeks, I would like to dashboard to show this historical information for quarterly metrics.
I realize this requires smartsheet to run a status check weekly and build on the count. I am fairly new to this tool and am not even sure if this is a capability.
Any help or guidance would be appreciated.
Help Article Resources
Check out the Formula Handbook template!