Help

List of all fields where checkbox is not checked

Topic Labels: Formulas
Solved
Jump to Solution
1254 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Kelly_Vorrasi1
6 - Interface Innovator
6 - Interface Innovator

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
Ben_Young1
11 - Venus
11 - Venus

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

3 Replies 3
Ben_Young1
11 - Venus
11 - Venus

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.

 

 

Kelly_Vorrasi1
6 - Interface Innovator
6 - Interface Innovator

Wow that works beautifully! Thank you so much! 

How would this work if you wanted to list the boxes that WERE checked? I have created a form that matches volunteers with potential jobs depending on their answers to three questions (video attached) and I want a field to be a consolidation of everything they have checked.
Thank you!

Thank you! 😊