jeudi 29 août 2019

How to add an If statement in Google Scripts

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