How to Record and compare previous status (stoplight color or dates)
I have a report I'm trying to emulate in Smartsheet. The report has critical milestones in column a, and stoplight colors in Column b, and c. Column b shows the prior week and Column c shows the current week. The intent of the report is to show if a milestone has trended the same, improved, or gotten worse by comparing the change in colors over time.
How would I capture the prior week information from a sheet so I can compare it to the current week?
Any suggestions would be greatly appreciated.
Help Article Resources
Check out the Formula Handbook template!