Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

List of all fields where checkbox is not checked

Topic Labels: Formulas
Solved
Jump to Solution
88 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi Folks, 

I've been trying to come up with an elegant solution to this and am hoping the community here can help me. I have several fields of checkboxes marking different assets available in our library. I would love to create a signal field that would list which fields are still unchecked. Is this possible? I've tried a few variations but nothing is working. 

Thanks!

1 Solution

Accepted Solutions

Hey @Kelly_Vorrasi1

Here's a fun formula that dynamically summarizes your checkbox fields and provides return values based on what's currently provided:

IF(
    AND(
        {LAS Art}, {BPO Art}, {IT Art}, {JP Art}, {POL Art}, {FR Art}),
    " All Fields Completed",
    IF(
        AND(
            NOT({LAS Art}),
            NOT({BPO Art}),
            NOT({IT Art}),
            NOT({JP Art}),
            NOT({POL Art}),
            NOT({FR Art})
        ),
        " Missing All Fields",
        TRIM(
            "Missing Fields:\n" & 
            IF(
                NOT({LAS Art}),
                "- LAS Art\n"
            )
            &
            IF(
                NOT({BPO Art}),
                "- BPO Art\n"
            )
            &
            IF(
                NOT({IT Art}),
                "- IT Art\n"
            )
            &
            IF(
                NOT({JP Art}),
                "- JP Art\n"
            )
            &
            IF(
                NOT({POL Art}),
                "- POL Art\n"
            )
            &
            IF(
                NOT({FR Art}),
                "- FR Art\n"
            )
        )
    )
)

Here's what it looks like in Airtable:

Ben_Young1_0-1674259677777.png

Everything is pretty cleanly nested so that you can extract any key parts of the formula if you'd like to tweak things around to fit your needs.

Always happy to answer any questions about the formula or how it works.

 

 

See Solution in Thread

2 Replies 2

Hey @Kelly_Vorrasi1

Here's a fun formula that dynamically summarizes your checkbox fields and provides return values based on what's currently provided:

IF(
    AND(
        {LAS Art}, {BPO Art}, {IT Art}, {JP Art}, {POL Art}, {FR Art}),
    " All Fields Completed",
    IF(
        AND(
            NOT({LAS Art}),
            NOT({BPO Art}),
            NOT({IT Art}),
            NOT({JP Art}),
            NOT({POL Art}),
            NOT({FR Art})
        ),
        " Missing All Fields",
        TRIM(
            "Missing Fields:\n" & 
            IF(
                NOT({LAS Art}),
                "- LAS Art\n"
            )
            &
            IF(
                NOT({BPO Art}),
                "- BPO Art\n"
            )
            &
            IF(
                NOT({IT Art}),
                "- IT Art\n"
            )
            &
            IF(
                NOT({JP Art}),
                "- JP Art\n"
            )
            &
            IF(
                NOT({POL Art}),
                "- POL Art\n"
            )
            &
            IF(
                NOT({FR Art}),
                "- FR Art\n"
            )
        )
    )
)

Here's what it looks like in Airtable:

Ben_Young1_0-1674259677777.png

Everything is pretty cleanly nested so that you can extract any key parts of the formula if you'd like to tweak things around to fit your needs.

Always happy to answer any questions about the formula or how it works.

 

 

Wow that works beautifully! Thank you so much!