Checkbox components allow you to toggle
FALSE values in your spreadsheet:
These are great for binary choices that your users need to make on your list items.
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: