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.

Hudson

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!