Google Apps Script conditional loop
I am trying to loop over one column in my sheet and set the value an
adjacent cell dependent upon the value and color of the active cell. this
is what I've tried but I cannot seem to get working...
function setValue(){
var sheet = SpreadsheetApp.getActiveSpreadsheet();
var end = SpreadsheetApp.getActiveSheet().getLastRow();
for( var i = 1; i < end + 1; ++i){
var value = sheet.getRange(i, 4).getValue();
var color = sheet.getRange(i, 4).getColor();
if (value == "Authenticated" && color == "#ffffff") {
sheet.getRange(i, 5).setValue("True");
}
else {
sheet.getRange(i, 5).setValue("False");
}
}
}
Please help. I'm new to Apps Script. Thanks!
No comments:
Post a Comment