Archived 2017 Posts
Archived 2017 Posts
Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Report on Previous Entries
Chris Mondeau
Community Champion
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?
Comments
-
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
This discussion has been closed.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.5K Get Help
- 468 Global Discussions
- 156 Industry Talk
- 511 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 156 Just for fun
- 81 Community Job Board
- 520 Show & Tell
- 35 Member Spotlight
- 3 SmartStories
- 307 Events
- 35 Webinars
- 7.3K Forum Archives
Trending Posts
- I am struggling to come up with a solution to convert a timestamp string to a date. The format of the timestamp has the month spelled out as in "January 25, 2025 9:15 am." Many thanks, TARA
- I saw someone else asked the same question in another thread https://community.smartsheet.com/discussion/108384/including-a-comma-for-currency-within-an-existing-formula but the answer was very confus…
- I need this formula to return the pay date {pay date} if the hire date [Hire/QE Date]@row is between the date range for the beginning of the pay period {Begin Date} to the end of the pay period {End D…
