Is it possible to export only the newest entries of a Smartsheet to Excel?
I am working on a group project using Smartsheet. One person's job is to add 70 rows each week. The next person exports the data to an Excel spreadsheet. They want to be able to export only the new rows entered, not the entire dataset. Is there a way to only export certain or newly added rows? Thanks!!
Answers
-
You could achieve that by creating a report from the sheet that would be filtered to only display entries from the last 7 days, if the sheet doesn't contain a date created date field then that would need to be added.
The report could also be set to email automatically on a set period, save the second person having to complete the manual task of exporting and just working with the received info.
Hope that helps
Thanks
Paul
-
Hi Paul,
This was very helpful, thank you so much!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 439 Global Discussions
- 138 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives