Switch & Checkbox

Toggle true/false values

The Switch and Checkbox components allow you to toggle TRUE/FALSE values in your spreadsheet:

These are great for binary choices that your users need to make on your list items.

The Switch Component

Formulas in your sheet can use IF to calculate different values based on switch positions. For example, this Meeting Room Reservation app lets users toggle a switch to reserve a room, and then updates labels from 😃 Available to 🛑 Unavailable based on the switch:

To create this functionality with the IF formula, adapt the following formula for your sheet: =if(A2=false,"🔴Busy","✅ Free!")

Don't be surprised if Google sheets turns your TRUE/FALSE text into switches. They act in exactly the same way.

Example of switches in Google sheets