Report on Previous Entries

Chris Mondeau

Hello!

I'm curious what would be the best way to report a cells previous vs current value.

For example, last month we had a status set to 15%, and this month it's updated to 20%. I'd like to see the 5% change as a percentage, or even an icon on a sight.

Can this be done natively through the changelog, or would I have to collect new rows to note the changes?

Kara Lumley

Hello,

You can see cell changes via the Activity Log, but it may be more helpful to get the cell history changes via the API - that way you can compare data at a large scale.

https://smartsheet-platform.github.io/api-docs/#get-cell-history

Best,

Kara