Google Sheets Checkboxes
Checkboxes in Google Sheets has become a spreadsheet staple! Incredibly easy in Google Sheets. Highlight the range you want checkboxes and use the Insert menu to choose “Checkbox.”
True or False
The checkboxes are the value of the cell. When checked the value is true. When not checked the value is false.
If Statement
A really handy formula to use with checkboxes is IF.
=if(A2=true,”Book returned”,”Missing”)
What this says is IF the checkbox in cell A2 is checked put the words Book returned in this cell. Note that the quotations around the text for what words to put in the cell are required. The value of true or false is NOT text so you would not use quotes, just type true to check if the checkbox is checked.
1 thought on “Checkbox: Check It”
Awesome! Did you know that the checkboxes are also considered as numerical values?
I was looking for a formula to calculate grades with IF function, but I realized that sheets considers checked boxes as “1” and it is really handy in formulas.