Use Checkboxes as Radio Buttons with the Properties Service

A follow-up to Use Checkboxes as Radio Buttons with FOR() Loop
Use Checkboxes as Radio Buttons using the Properties Service.

Important notes:
DO NOT run the script manually, it will fail.
Make sure the Property gets properly set on the first pass.

Sheet (to copy – go to File > Make a copy)

function onEdit(e){
if (e.range.columnStart != 2 || e.range.rowStart == 1 || e.range.rowStart > 8 || e.value != “TRUE”) return;
let r = PropertiesService.getScriptProperties().getProperty(“range”);
if (r == null){

Connect with me:
• Twitter @FarrisSpencer
• Google Product Expert


Leave a Reply

Your email address will not be published. Required fields are marked *