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