Tracking the Specific Time of a Cell in One Status

Hi all.

I am trying to simply and easily track the time in days a cell is in red status (General Health column in picture below) until it changes. Nonetheless, although we can easily keep track of row changes with helper columns, I really cannot figure out how to do so specifically for one cell.

Any recommendation on how to carry on that specific calculation? I have thought of support columns and many other solutions, but they either don't update automatically when something becomes or it is no longer red. Does anybody have a clear picture on how to tackle it? It would be highly appreciated.

Thank you!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!