Document the value of function / calculated field every day

Hi all,

I have 2 sheets:

1) working sheet where all tickets are logged + their status is maintained

2) calculation sheet with fields showing e.g. number of open / closed tickets and so on (calculated by formulas which refer to the working sheet 1). These values are used for dashboards and so on.

I wish to automatically track/log calculated values e.g. number of open tickets on a daily basis in a separate sheet. So it should be something like:

Date: Open tickets:

26/03/2020 10

27/03/2020 8

... but automatically created by smartsheet so I don't have to log it manually every day.

Is something like that possible? Is there a formula to get the value copied from a calculated field and then stop refering to that field so the value does not change every time the calculated field changes?


Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    You can use a Copy Row automation set to run at a specific time of your choosing. This will create a static copy of your data. You can include a Created(date) type column on the target sheet to log when those stats were pulled.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!