Google sheets – Installable Triggers
I’m trying to run the onChange function below using triggers but keeps failing. The error is: TypeError: Cannot read properties of undefined (reading ‘getSheet’) at onChange(Code:161:21) Line 161 is var sheet = range.getSheet(); My function: var range = e.range; var sheet = range.getSheet(); if (sheet.getName() == ‘SMS’ && range.getRow() > 1 && range.getColumn() < 3) … Read more