jeudi 11 novembre 2021

Clear a range of cells in Sheets using a checkbox

I'm creating spreadsheet board games with my students, and one is making a tic-tac-toe game. They tried adding a checkbox to clear a range for another round.

I know this will involve a specific App Script, but I am not sure which one and how to tell it to use the true/false with the checkbox and how to clear a specific range.

Here is a copy of the sheet I am using

Any help would be greatly appreciated!




Aucun commentaire:

Enregistrer un commentaire