Tracking "Time at Current Stage"


Hi Guys

I have a question regards tracking comments/ current stage of ticket items

We have an export that is added via the Data Uploader which contains "Last Week" & "This Week" fields. We are hoping to expand the range by which we can track how long an item has been at a certain stage.

The idea is we add the file via the uploader and move every item one to the left to allow to provide an update for "This Week")

I am just wondering is there an easy way to count how long an item has been stuck at a stage? Is it just a case of doing a big nested IF AND formula, or can anyone think of a quicker way?




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!