Lots of data to manage

[ShantanuIyengar]

You can try to move rows which aren’t being used to other sheet.

Scripts, scripts, scripts!

A script to move rows from one sheet to another based on certain conditions. I run this trigger every 24 hours to get rid of past data and save it as a backup so my apps are always easier and quicker to load. function moveRows() { var ss = SpreadsheetApp.getActive(); var source = ss.getSheetByName('Sheet1'); var val = source.getDataRange().getValues(); var PDate = new Date(new Date().setHours(0,0,0,0)) for (var row = val.length - 1; row >= 0; --row) { Logger.log("C…