Conditionally Insert Checkboxes
How to insert checkboxes when a condition is met from manual data
Sheet (make a copy from the File menu)
https://docs.google.com/spreadsheets/...
Script
function onEdit(e){
if (!e) throw "Do not run from Editor";
insertFollowupCheckbox(e);
}
function insertFollowupCheckbox(e){
const r = e.range;
if (r.columnStart != 2 || e.value greater_than_sign 3) return;
r.offset(0,1).insertCheckboxes();
}
I use AppsScript Color for the dark theme, OBS Studio to record, and a Blue Yeti microphone
Connect with me:
• spencer.farris@gmail.com
• spencerfarris.me
• www.linkedin.com/in/spencer-farris/
• Twitter/X @FarrisSpencer
• Google Product Expert support.google.com/docs/profile/12305
Donate on Paypal: spencer.farris@gmail.com
On this page of the site you can watch the video online Conditionally Insert Checkboxes with a duration of hours minute second in good quality, which was uploaded by the user Spencer Farris 15 April 2024, share the link with friends and acquaintances, this video has already been watched 1,884 times on youtube and it was liked by 28 viewers. Enjoy your viewing!
