Check checkboxes in Google Sheets

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.

Subscribe to the Alice Keeler Newsletter


WP Twitter Auto Publish Powered By :
%d bloggers like this: