Is there a way to archive a sheet at end of day?
We have a sheet tracking product output that is updated every 15 minutes. By end of day the sheet has well over 1000 rows of data, and gets a little clunky to work with (takes a while to save/sort). We use the sheet everyday to run a report showing productivity and tie in some metrics for quality. Currently, we are exporting this sheet daily to excel, and creating a new sheet (from template) in smartsheet. Is there a better (more efficient) way to archive this sheet every day and have a blank version ready to go for the next day?
Answers
-
Have you looked into creating a workflow that used Move Row to move all rows to another sheet at the end of the day so you start with the same blank sheet the next day?
Cheers,
Ramzi
Ramzi Khuri - Principal Consultant @ Cedar Tree Consulting (www.cedartreeconsulting.com)
Feel free to email me: ramzi@cedartreeconsulting.com
💡 If this post helped you out, please help the Community by marking it as the accepted answer/helpful.
-
I haven’t, but this seems like a great solution! Looking at the automated workflows...do you know if there is a way to do this by chunks of time (not just date)? For example, if I wanted data collected on the master sheet between 1AM and 3PM on 10/26 to go to sheet 1, and data collected from 3:01 PM to 12:59 AM to go to sheet 2?
-
Ramzi Khuri - Principal Consultant @ Cedar Tree Consulting (www.cedartreeconsulting.com)
Feel free to email me: ramzi@cedartreeconsulting.com
💡 If this post helped you out, please help the Community by marking it as the accepted answer/helpful.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 213 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives