As the title, is there a way to have a print of the content of a sheet periodically?i.a., I'd like to have a trigger that every Monday at 08.15 A.M. copy the contents of a group of a cell of a sheets into another specific group of cell of another sheets.
Google Spreadsheet - periodically stamp sheet contents
google spreadsheets;google apps script
var sheet1 = SpreadsheetApp.getActiveSheet.getSheetByName(mySheet1);var sheet2 = SpreadsheetApp.getActiveSheet.getSheetByName(mySheet2);sheet1.getrange(A1:C7).setvalues(sheet1.getrange(B1:D7).getvalues);Where A1:C7 is the destination range and B1:D7 is the source range. I have not tested it but it should be like this.