Previous Values as historical values

Hello all,

I am in need of a way to store previous values (mostly symbols showing project progress) into a sheet that would allow for comparison if needed. The main sheet would have current status and a harvey ball symbol either green, red or yellow. Then next week, I want to update based on project status but I don't want to lose sight of previous value. Anyone has a workaround this?

Thanks in adcance!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!