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.
Run Report on 'Highlighted Changes'
we have a large smartsheet with 300 (plus) rows and 25 columns and wish to quickly focus in on any cells that have had a change. I understand how to use the 'highlight cells' function, but the problem is that i then need to scroll down through all the data to see any highlighted changes. Is there a way of getting what we want or creating a report?
Comments
-
Hi Si,
You could add a column with the Auto number/system, using the modified date and then use that to run a report that would bring changes made since whatever date you choose to run the report by. I would continue to turn on the highlighting so you'll know which fields were modified in the report. Hope that helps, Peace!
-
Hi Heidi, Thanks.
would this work-round necesitate changing the parameters each time we wanted to run the report?
-
Hi Si,
It depends on how offten you are looking for changes. If your looking for changes that happened today and your report is pulling modifications from today, then NO, you would not have to change the parameters of the report. Take a look at all the options available in the reporting tool. It's a very quick change if you do need to make the change.
Peace!
-
@Si,
I'm trying to do the same thing, but with 5 sheets for a total of 3000lines. Thought a report would do the trick, just highlight the recent changes. However, reports don't always catch what you're looking for, like ALL the changes.
Report WARNING, the "modified" system value does not take into account any changes to the comments or attachments. So, if you're running a report and looking at changes in the past day, then the report will outright ignore any comment changes unless they were accompanied by cell changes in the target sheet.
Total bummer
-
There is also no way to programmitally capture the change using formulas.
Testing with Zapier (www.zapier.com) shows that they don't see comments/attachments as a change either.
You should notice that when a comment/attachment is updated, the "Save" icon does not change.
This leads me to believe that while the change looks easy on the surface, it probably isn't.
Craig
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 456 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives