I know there are other questions on this, such as here: https://community.smartsheet.com/discussion/rss-feed
But in the interests of etiquette I thought I better start my own thread.
So I have a sheet where I add a new row at the top. Every three months or so I reach the 5000 row limit and have to move rows out manually. I'm looking for a way to automate that. I currently use a Zapier Zap to move rows out of a different sheet so I know that moving rows out is possible.
So what I'd like to do is move rows out if they are older than say 2 months to a different sheet. And I'd have to have a zap running on that sheet too - cascading to several sheets over time....
However to do it I'd need to trigger when rows are updated - triggering on new row doesn't work because it's always the latest date. Triggering on updated rows is good because new rows added at the top causes each row below to update, then I would check each row's date and if older than 2 months move it out. The problem lies with the fact that Zapier, once a certain number of tasks are hit, puts the zap on hold. And each updated row causes a Zapier task. So I get a task for each row of the sheet, which of course I'm hoping to get up to around 4,900 to take advantage of the whole spreadhseet.
Can anyone think of a way of getting around this? For me the API isn't a solution as I have no clue how to program for that. I guess I could learn but it would be a steep learning curve.
Cheers for your help,