Automated Workflow in archiving the data in the sheet

We are using the Smartsheet form to collect the real-time customer experience survey data. One of the challenges is, after a few months, the number of rows in the sheet will approach the 20,000 rows limit. Therefore, we need to manually go in and move some of the older data to a new sheet to allow the space for additional submission. We don't remove all the data since we still use newer data for our reports and dashboards.

Do any of you have set up any automation to handle this? For example, every two months, move the data that is greater than two months old to a newly created sheet. Any suggestion is appreciated.

Thank you.

Best Answer

Answers