- 11 Dec 2023
- 1 Minute to read
- Print
- DarkLight
- PDF
Using checkbox fields in formulas
- Updated on 11 Dec 2023
- 1 Minute to read
- Print
- DarkLight
- PDF
This article covers how to use checkbox fields and formulas to streamline your team's and organization's work.
All plan types | |
Platform(s) | Web/Browser, Mac app, and Windows app |
Related reading |
Using checkbox fields in formulas in Airtable
Using checkbox fields in formulas
NOTE
When working with checkbox fields and formulas, "= 0" means that a checkbox is deselected, and "= 1" means that a box is selected.
Checkbox fields can also be extremely useful in Automations. They are of particular value when using the “When a record matches conditions" trigger.
So, to make a formula field which returns A when a box has been checked, and B otherwise, you would need to set the formula for the formula field as:
IF(Checkbox = 1, "A", "B")
NOTE
If you'd like to see how to use a Rollup field to count all the checkboxes within a field, check out this Community post.
FAQs
How do I return a checkbox as the result of a formula?
If you are looking to return a checkbox as the result of a formula, you won't be returning a checkbox field, but rather a checkbox emoji. Check out this support article for information about writing formulas with emojis.