Previous Values as historical values
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
Check out the Formula Handbook template!