This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
function setBackupTrigger() { var sSht =
SpreadsheetApp.openById(sheetID); ScriptApp.newTrigger(“resetTrigger”)
.forSpreadsheet(sSht) .onChange() .create(); } function resetTrigger(e)
{ var sSht = e.source; var sht = sSht.getActiveSheet(); try { var
...
How to deal with this error: Invalid value (line 3, file “Code”) line 3:
var controlLimit =
(SpreadsheetApp.openById(sheetID).getSheetByName(“backup”).getRange(“E2”).getValue()
!== “”) ?
Number(SpreadsheetApp.openById(sheetID).getSheetByName(“backup”...