Clear Cell When Adjacent Cell Equals Value

Question

I have a spreadsheet with a time-driven trigger that clears a range every week.

This is my current script.

---

function clearWeekly() {
  //replace 'Sheet1' with your actual sheet name
  var sheet = SpreadsheetApp.getActive().getSheetByName('OnGoing');
  sheet.getRange('F3:F').clearContent();

}

---

I want to update my script so that it clears Column F only where the cell value in Column B = SMM. Column F consists of checkboxes.

Can someone help here?

You can view my spreadsheet here: https://docs.google.com/spreadsheets/d/1r7yjUMdK4eDY328Zeg41pYHTmjHa5slzBLEnVP2GzI8/edit?usp=sharing

Answer 1

I was able to make it work using the code below. I used this answer as a reference: Google sheets loop search for string and clear adjacent cells

function deleteRows() {
    var sheet = SpreadsheetApp.getActive().getSheetByName('OnGoing');
  var lr=sheet.getLastRow()
  var lc=sheet.getLastColumn()
  var a = sheet.getRange(3, 1, lr, lc).getValues();
  for (var i = 0; i < a.length-1; i++) {
          if (a[i][1].indexOf("SMM")!= -1){
           var delete1=sheet.getRange(i+3, 6, 1, 23)
           var delete2=sheet.getRange(i+3, 29, 1, 6)
           delete1.clearContent()
           delete2.clearContent()
   }}}