Tracking the Specific Time of a Cell in One Status
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.
Help Article Resources
Check out the Formula Handbook template!