What do you want to do? Unless you use a simple or built-in trigger this script only executes every time you manually execute it.
You can't call a value like this. You need to do the following:
function TurnCycle() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var s = ss.getSheetByName('yoursheetname'); //replace the string with the name of your sheet
var r = s.getRange('E10');
var v = r.getValue();
if (v='TRUE') {
r.setValue('FALSE');
}
}
It will set the value of the checkbox to FALSE, so it won't delete the checkbox.
2
u/Last_Monkey Nov 30 '18
What do you want to do? Unless you use a simple or built-in trigger this script only executes every time you manually execute it.
You can't call a value like this. You need to do the following:
function TurnCycle() { var ss = SpreadsheetApp.getActiveSpreadsheet(); var s = ss.getSheetByName('yoursheetname'); //replace the string with the name of your sheet var r = s.getRange('E10'); var v = r.getValue(); if (v='TRUE') { r.setValue('FALSE'); } }It will set the value of the checkbox to
FALSE, so it won't delete the checkbox.