There should be a way to automate the creation of a new sheet when moving rows so that the sheet does not reach its cell limit and historical data is archived neatly. I have a sheet that logs every training event using an api to write in the training events scheduled. At the end of each month, I would like to move the past months events to a new sheet that gets created and named based off the month column because if I move it to the same sheet, there is no room for multiple months. This does not seem like it would be too difficult (hopefully) since moving rows is already an automation. This would be very helpful. Thank you!
This is the same issue that was mentioned in this post in 2021: https://community.smartsheet.com/en/discussion/75749/automated-workflow-in-archiving-the-data-in-the-sheet?utm_source=community-share
