Using checkbox fields in formulas
  • 11 Dec 2023
  • 1 Minuto para leer
  • Oscuro
    Ligero
  • PDF

Using checkbox fields in formulas

  • Oscuro
    Ligero
  • PDF

The content is currently unavailable in Spanish. You are viewing the default English version.
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.


¿Te ha sido útil este artículo?