Javascript – Is there a way I can apply a function to one specific sheet?
Is there any way to apply this function to a sheet named "Production Log"? function CopyDatatoLog() { var spreadsheet = SpreadsheetApp.getActive().getSheetByName('Production Log'); spreadsheet.getRange('B8:B11').activate(); spreadsheet.getActiveSheet().insertRowsBefore(spreadsheet.getActiveRange().getRow(), 4); spreadsheet.getActiveRange().offset(0, 0, 4, spreadsheet.getActiveRange().getNumColumns()).activate(); spreadsheet.getRange('A8:BL11').activate(); spreadsheet.getRange('4:7').copyTo(spreadsheet.getActiveRange(), SpreadsheetApp.CopyPasteType.PASTE_VALUES, false); }; I keep getting this error "TypeError:…