Skip to main content
4 of 4
Commonmark migration

UPDATE(April 2019)

You can now directly insertCheckboxes(or removeCheckboxes) on a Range or RangeList without any workarounds. You can also change the checked value/unchecked value using alternate method signatures found in the documentation.

Snippet:

SpreadsheetApp.getActive() .getRange('Sheet2!A2:A10') .insertCheckboxes(); 
TheMaster
  • 51.6k
  • 7
  • 76
  • 102