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,



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!