How to calculate elapsed time between status changes ?



Is there a way to calculate the elapsed time between two status changes ? I would need to know how much time it took for the status to change from yellow or red to green.

Ideally, I would like to be able to calculate a mean per territory, department and my whole plant on time between yellow/red to green status change.

Here's a view of the source sheet

And the report from that source sheet

Thank you!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!