title: Reset Checkboxes and Delete Notes on Defined sheets
body: <p>I need to reset checkboxes to FALSE (Unchecked) and also delete all notes from defined sheets.</p>
  
  <p>Also need a script that deletes all notes from a Google sheet (all sheets)</p>
  
  <p>I tried combining numerous different scripts.</p>
  
  <p><a href="https://webapps.stackexchange.com/questions/115076/how-to-run-script-on-multiple-google-sheet-tabs">https://webapps.stackexchange.com/questions/115076/how-to-run-script-on-multiple-google-sheet-tabs</a></p>
  
  <p><a href="https://stackoverflow.com/questions/51185819/re-set-checkboxes-to-false-google-apps-script/54740966#54740966">Re-set checkboxes to false - Google Apps Script</a> -- The problem with this script is that is turns cells with a value of 1 into cells that say "FALSE"</p>
  
  <pre><code>function ResetCheckBoxesAndClearNotesOnDefinedSheets(){
      var tabs = [
          'Checkboxes 1',
          'Checkboxes 2',
          'Checkboxes 3',
          'Another Checkbox tab',
          'Yet another checkbox tab'
      ];
  
  
    //LOOP THROUGH TABS LISTED ABOVE
      var ss=SpreadsheetApp.getActiveSpreadsheet();
      for (var i = 0; i &lt; tabs.length; i++) {
          var sheet=ss.getSheetByName(tabs[i]);
  
    //CLEAR NOTES ON TABS LISTED ABOVE    
        sheet.clearNotes();
  
   // CLEAR CHECKBOXES ON TABS LISTED ABOVE
  
  var dataRange = sheet.getRange('A:I');
  var values = dataRange.getValues();
  for (var i = 0; i &lt; values.length; i++) {
    for (var j = 0; j &lt; values[i].length; j++) {
      if (values[i][j] == true) {
        values[i][j] = false; // Modified
      }
    }
  }
  dataRange.setValues(values);
  
  
  }//end of  sheets loop.
    }
  </code></pre>
  
  <p>ACTUAL RESULTS:
  -It does not loop through the pages and delete the notes.  It also does not loop through and change all checkboxes in the tabs to unchecked.. and it sometimes replaces a "1" with a FALSE</p>
  
  <p>EXPECTED RESULTS:
  -Reset all checkboxes on defined sheets
  -Clear all notes on Defined sheets (or entire Spreadsheet)</p>