Teacher Tech blog with Alice Keeler

Paperless Is Not a Pedagogy

Alice Keeler

Checkbox: Check It

check checkboxes in google sheets
Checkbox: Check It
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.

1 thought on “Checkbox: Check It

  1. 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.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

© 2024 All Rights Reserved.

❤️ Become a Premium Teacher Tech Member

Regular price is $249. Save $150 and pay only $99 for the 2024/2025 school year!

Monthly installments is only $12 a month.

Exclusive Teacher Tech Content! 
Exclusive Online Courses
Premium Add-ons for Google Workspace
Office Hours with Alice
Weekly Check In Support
Exclusive Webinars
And more! 

Exit this pop up by pressing escape or clicking anywhere off the pop up.