How To Clear Checkboxes With Google Sheets and Appscript

If you want to clear checkboxes by simply running a code, you need to know How To Clear Checkboxes With Google Sheets and Appscript.

Here’s a simple sample code:

function clearCheckmarks() {
 var range = SpreadsheetApp.getActive().getRange("B2:B8");
 var values = range.getValues();
 values.forEach(function(row) {
   row.forEach(function(col) {
     range.setValue("False");
   });
 });
}

In this case, “B2:B8” is the range of the boxes in my Daily Writing Habit Tracker that you want to clear.

You’ll have to swap out the range in your sheet that you want to clear.