# Filter is not checking right 2 columns with boolean values

**URL:** https://community.glideapps.com/t/filter-is-not-checking-right-2-columns-with-boolean-values/59182
**Category:** Ask for Help
**Created:** [March 15, 2023, 9:45am UTC](https://community.glideapps.com/t/filter-is-not-checking-right-2-columns-with-boolean-values/59182 "2023-03-15T09:45:18Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![Ovi](https://avatars.discourse-cdn.com/v4/letter/o/3ab097/32.png) [@Ovi](https://community.glideapps.com/u/Ovi)
#### Post date: [March 15, 2023, 9:45am UTC](https://community.glideapps.com/t/filter-is-not-checking-right-2-columns-with-boolean-values/59182/1 "2023-03-15T09:45:18Z")

</div>

I have 2 columns with Boolean values  
InStock1 and InStock2

InStock2 - is taking the value on the switch button inside the app, as I can’t target the original table in that view  
InStock1 - has the values of stock

the data should be filtered if InStock1 is InStock2 and the category column has a certain value … the second is working right, but the first is not working when it’s not checked … anyone knows why ?

If I select the conditions : Is checked or Is not checked, then everything is working, only when compared to the other boolean column is not working , can’t figure out why

---

<div class="post-metadata">

### Author: ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [March 15, 2023, 11:43am UTC](https://community.glideapps.com/t/filter-is-not-checking-right-2-columns-with-boolean-values/59182/2 "2023-03-15T11:43:48Z")

</div>

Booleans can be in 3 states. True, False, or Blank. Is Checked and Is Not Checked do account for all 3 states. I’m not sure about comparing boolean to boolean though, but it might be possible that you are comparing Blank to False, which may not be a match.

---

<div class="post-metadata">

### Author: ![Ovi](https://avatars.discourse-cdn.com/v4/letter/o/3ab097/32.png) [@Ovi](https://community.glideapps.com/u/Ovi)
#### Post date: [March 15, 2023, 12:03pm UTC](https://community.glideapps.com/t/filter-is-not-checking-right-2-columns-with-boolean-values/59182/3 "2023-03-15T12:03:31Z")

</div>

so how do I know when is blank and when is False as the checkbox is the same ?

---

<div class="post-metadata">

### Author: ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)
#### Post date: [March 15, 2023, 12:33pm UTC](https://community.glideapps.com/t/filter-is-not-checking-right-2-columns-with-boolean-values/59182/4 "2023-03-15T12:33:13Z")

</div>

You can’t. An unchecked box has the value “false” or “empty”.

You might want to reverse the logic and verify for “true” instead.