Time spent in a particular status (Count of days)

Options

I've been racking my brain and maybe thinking too deep on it but can't figure out a way yet. Ok so let's say you have 3 status's

Open

In Progress

Closed

You want to have a counter that shows how many days it's in that particular status. I thought about the column that shows last updated but there are other columns of information that get updated so that wouldn't work. How can I get a column to show how many days a line has had a particular status?

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!