I’m attempting to apply borders to cells conditionally via apps script, but my code is not registering the two (obviously met) conditions. Looking for a logic and syntax check <3
Sheet:
stackoverflow noobs can’t attach images so here’s a link
Code:
function doBorders() {
let ss = SpreadsheetApp.getActiveSpreadsheet();
let sss = ss.getActiveSheet();
let doBorder = sss.getRange("A5");
let checkBox = sss.getRange("B5");
let checkState = checkBox.isChecked();
let bRow1 = sss.getRange("A1:B1");
let bRow2 = sss.getRange("A2:B2");
let bRow3 = sss.getRange("A3:B3");
if (doBorder == "Do Borders:" && checkState == true) {
bRow1.setBorder(false, false, true, false, false, false,'Black', SpreadsheetApp.BorderStyle.SOLID);
bRow2.setBorder(false, false, true, false, false, false,'Black', SpreadsheetApp.BorderStyle.SOLID);
bRow3.setBorder(false, false, true, false, false, false,'Red', SpreadsheetApp.BorderStyle.SOLID);
Logger.log('Conditions met. Borders added.');
} else
bRow1.setBorder(false, false, false, false, false, false);
bRow2.setBorder(false, false, false, false, false, false);
bRow3.setBorder(false, false, false, false, false, false);
Logger.log('Conditions not met. No borders.');
}
I’ve tried both checkBox == true and checkState == true. Same result.
Execution Log:
“Conditions not met. No borders.”