Checkmarks in range A2:A75, I want to check if the matching E cell is blank and if not reset the checkmark daily.
All I have is this with a trigger for weekly reset for now, but not sure how to go about only resetting specific checkmarks daily as stated above:
function resetBoxes() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getActiveSheet();
sheet.getRange('A2:A75').setValue(false);
}
New contributor
Sheriff K is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.