Help

This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.

Filter to only show records with checkbox UNchecked?

cancel
Showing results for 
Search instead for 
Did you mean: 
Adam_Green
5 - Automation Enthusiast
5 - Automation Enthusiast

Unless I’m missing something major, there doesn’t seem to be an out-of-the-box solution which allows you to filter so as only display records which have a checkbox field unchecked. Checked yes, but unchecked no.

Is this an accidental oversight by Airtable? Some reason why this is not possible? Seems like it would be an easy and really great thing to implement.

Unless of course this is actually possible and I’m missing something really obvious… (am new to Airtable!)

4 Comments
Adam_Green
5 - Automation Enthusiast
5 - Automation Enthusiast

I realise that you can do a “workaround” using a formula , e.g. IF(Checkbox = 1, “A”, “B”), then filter “for is not A”

JonathanBowen
13 - Mars
13 - Mars

Hi @Adam_Green - your formula will work, but you can actually filter on checkbox unchecked - like this:

Screenshot 2020-05-01 at 16.04.08

as opposed to this (filter if checked):

Screenshot 2020-05-01 at 16.04.13

JB

Adam_Green
5 - Automation Enthusiast
5 - Automation Enthusiast

ahh thank you Jonathan! I was too fixated on the “is”/“is not” choice, rather than seeing the unchecked checkbox as actually being a thing unto itself which would have consequence.

Frank_Vittorini
4 - Data Explorer
4 - Data Explorer

Is there a way for the checkbox to disappear completely after being checked?