Populate a cells value with the previous value of another cell


I am looking to have a rolling history of values. I want the cell to the right to have the previous value of the cell to the left. In other words, if I update the left cell, I want the left cells old value to move over the right cell? I cant seem to find a way to do this.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!