The aim of this tutorial🔍 is to create a simple sheet containing list of checkboxes and a button that resets all of them at once for the quality review

TL DR; just take and populate the template from

1. Checkbox reset

function ResetCheckboxesOnSheet() {
  var ss=SpreadsheetApp.getActive();
  var sh=ss.getActiveSheet();
  var rg=sh.getDataRange();
  var vA=rg.getDataValidations();
  var cbA=[];
  for(var i=0;i<vA.length;i++) {
    for(var j=0;j<vA[i].length;j++) {
      var rule=vA[i][j];
      if(rule!=null) {
        var criteria = rule.getCriteriaType();
        if(criteria == SpreadsheetApp.DataValidationCriteria.CHECKBOX) {


— from Google Script to clear Checkboxes and Notes in cells unexpectedly clears HYPERLINKS as well - Stack Overflow

2. Add button


3. sources