MENU
    Using checkbox fields in formulas
    • 11 Sep 2024
    • 1 Minute to read
    • Dark
    • PDF

    Using checkbox fields in formulas

    • Dark
    • 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")
    Plain text

    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.

    Do Switch() functions support Boolean validation of checkbox fields as laid out in the examples in this article?

    No, Switch() functions do not support Boolean validation. Additionally, in some cases if you combine Switch() functions with IF() statements, you may render the equation unable to validate whether the checkbox is checked or unchecked by using a “1” or “0” in the equation.


    Was this article helpful?