Archiving Rows

How do you go about archiving large data sets from sheets? I know you can create automations to move rows to another sheet but what happens when that sheet gets too large as well? I have thousands of entries that happen every day and I am trying to use data shuttle to offload the data but with offloads, it just replaces the same document each time which I do not want to do. I want to be able to still access all my data for at least a year. Is there a way to get all my data from a sheet into data table?
Basically I want all rows from the last 4 months to stay in the sheet but the rest i want to be able to export or offload to an excel file so that I have that data still. Is there a way to automatically do this with data shuttle or data table or do I need to go to my archive sheet, export it and delete everything on a set frequency or make additional archive sheets?
Answers
-
If your Smartsheet license includes API Tokens it's worth exploring that route. You can customize just about anything you want. It would require novice level knowledge with a programming language like Python, but shouldn't be terribly difficult to achieve. I've been able to create automated exports from Smartsheet to Excel on a daily basis. Asking straightforward prompts with ChatGPT has been an incredible asset for the framework in coding.
https://www.linkedin.com/in/zchrispalmer/
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives