Using checkbox fields in formulas
  • 11 Dec 2023
  • 1 Minute to read
  • Dark
    Light
  • PDF

Using checkbox fields in formulas

  • Dark
    Light
  • PDF

Article Summary

This article covers how to use checkbox fields and formulas to streamline your team's and organization's work.

Plan availability

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")

checkboxFX_5_4_2021

checkboxFormula_5_4_2021

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.


Was this article helpful?