How to calculate number of days a project is at a certain status?
I am looking for a way to calculate the number of days a project is on hold based on a change of status.
In my theoretical planner, I set a project start date and input an estimated project duration. This calculates a predicted end date. I have a column where I can define the project status, these are "In Progress", "On Hold" and "Complete".
I would like to track the cumulative number of days the project has been placed "On Hold" over the lifetime of the project. This will be defined as the delays. The projects are likely to change status a number of times over the life time of the project.
A potential solution I can think of is to create a workflow to records the date every time the status is changed to "On Hold" which will copy the row of data into a separate grid. Then from that count the number of days the project has been changed into that status.
Would anyone be able to advice whether a formula could be devised to calculate this "Delays" value?
Help Article Resources
Check out the Formula Handbook template!