I am trying to add an If Statement to my code. The result I want to end up with is similar to this:
If C3:C = 'Y' then clear B3:B
The code below will clear B3:B, but I can't get an If statement to make this script run on the condition of another cell.
function clearData() {
var sheetActive = SpreadsheetApp.openById("1zzPUsGTIyCBqi1J9HAoFafaxBSOntCit0lfucf8SL78").getSheetByName("Manual Requests");
sheetActive.getRange('B3:B').clearContent();
Aucun commentaire:
Enregistrer un commentaire