Calculating average time spent in each phase

I am looking to create a sheet that moves through our 5 stages of work and how much time is spent in each phase. What is the best way to go about this?

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    The most straight forward would be to set up a date column for when you start each phase and then when you end the last phase (or when you start the first phase and then when you end each phase). From there it is subtracting one date form the other to determine how much time was spent in each.

    Slightly more complex would be using a dropdown for the different phases and then using Record A Date automations to automatically populate the date columns when the status changes.

    Both are relatively straight forward. It just depends on your structure and personal preference.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!