jeudi 9 septembre 2021

Have only one checkbox checked per row in google sheets

I am new to Google sheets, and I am having trouble writing a script to have only one checked box per row with two columns checked. I have two columns, E and F, both columns are all checkboxes. Each row can only have one box checked. If one is TRUE the other turns FALSE and vice versa. Also how can a cell be locked if checkbox is TRUE, and the only way to unlock the cell is with a password.

Thank you




Aucun commentaire:

Enregistrer un commentaire