Storing historical Data

Yogesh Kumar

Hi Folks,

I have a number column that is updated monthly and is overwritten with new values. However, I need some calculations based on previous data and current data in that column. For example - I want to calculate the deviation from the previous count to the new count. How is this achievable? Does Smartsheet have a formula to calculate based on historical data in a cell?

Paul Newcome

You would need to set up a copy row automation to copy the rows prior to update (or immediately after update) to capture historical data as static. Then you can use a formula with cross sheet references to pull the copied static data back into your working sheet for comparison.