Counting time
Dear community,
He use listed statuses to indicate the state of development of our planned tasks. We have a planned duration per task and the tasks are often paused to fit urgent matters or because they are blocked. I would like to be able to compare the planned duration of a task with the actual completion time, but due to the "pause" status, the completion duration is not as simple as "finish date" - "starting date". Is there a way to count "active" or "working" time in SmartSheet? Something like, "so long as the task status is "working", then accumulate time"?
Very kind regards,
Antoine.
Answers
-
Are you able to provide a screenshot with some examples manually entered?
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!