# How to Fix Filter with Multiple "Yes" Options in Glide

**URL:** <https://community.glideapps.com/t/how-to-fix-filter-with-multiple-yes-options-in-glide/76012>\
**Category:** Ask for Help\
**Created:** [August 31, 2024, 8:50am UTC](https://community.glideapps.com/t/how-to-fix-filter-with-multiple-yes-options-in-glide/76012 "2024-08-31T08:50:41Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Vey\_D](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/vey_d/32/79109_2.png) [@Vey\_D](https://community.glideapps.com/u/Vey_D)\
**Post date:** [August 31, 2024, 8:50am UTC](https://community.glideapps.com/t/how-to-fix-filter-with-multiple-yes-options-in-glide/76012/1 "2024-08-31T08:50:41Z")

</div>

I’m working on an app where I’m using a filter for safety labels on mushrooms. The labels I’m using are:

Yes (with caution)  
No

yes

Yes

Yes (with caution)

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [August 31, 2024, 9:41am UTC](https://community.glideapps.com/t/how-to-fix-filter-with-multiple-yes-options-in-glide/76012/2 "2024-08-31T09:41:27Z")

</div>

What’s your ideal outcome?

---

<div class="post-metadata">

**Author:** ![Vey\_D](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/vey_d/32/79109_2.png) [@Vey\_D](https://community.glideapps.com/u/Vey_D)\
**Post date:** [September 1, 2024, 8:35pm UTC](https://community.glideapps.com/t/how-to-fix-filter-with-multiple-yes-options-in-glide/76012/3 "2024-09-01T20:35:35Z")

</div>

Hi Thinh,

Thank you for responding to my post. I’m currently developing an app that helps users identify mushrooms using AI and provides emergency support if they encounter toxic varieties.

I’ve encountered an issue in Glide where I see duplicate **Filter** entries for “Yes” (okay to eat) and “Yes (with caution)” in my data. I would like to delete these duplicate entries, but I’m unsure how to do this within Glide. My data sheet looks fine, but the filter is showing duplicates. Could you please guide me through the correct process to resolve this?

Thank you for your assistance.

---

<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:** [September 1, 2024, 9:18pm UTC](https://community.glideapps.com/t/how-to-fix-filter-with-multiple-yes-options-in-glide/76012/4 "2024-09-01T21:18:33Z")

</div>

Do you have a screenshot of what you see? Just want to make sure I understand. If you see values in the filter that appear to be duplicates, then that could be that the column with the Yes/No values may have extra spaces, or something to cause the values in different rows to be slightly different, but unnoticeable to the naked eye.

---

<div class="post-metadata">

**Author:** ![Vey\_D](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/vey_d/32/79109_2.png) [@Vey\_D](https://community.glideapps.com/u/Vey_D)\
**Post date:** [September 1, 2024, 9:21pm UTC](https://community.glideapps.com/t/how-to-fix-filter-with-multiple-yes-options-in-glide/76012/5 "2024-09-01T21:21:05Z")

</div>

Thanks Jeff,

 ![glideFilter](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/6/e6a137d7790d0aa6c651d9320c903abe68621f2b.jpeg)  
This is my data  
 ![glideDataFilter](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/6/b6b1d1c12938f6aa2ba38b04637c82280799e129.png)

---

<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:** [September 1, 2024, 9:24pm UTC](https://community.glideapps.com/t/how-to-fix-filter-with-multiple-yes-options-in-glide/76012/6 "2024-09-01T21:24:50Z")

</div>

Well for starters I see `yes` and `Yes` which are different because one has a capital letter and one doesn’t. The filter is showing all non duplicate values from your data. For the `Yes`, it needs to be consistent if you only want to see it once in the filter.

---

<div class="post-metadata">

**Author:** ![Vey\_D](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/vey_d/32/79109_2.png) [@Vey\_D](https://community.glideapps.com/u/Vey_D)\
**Post date:** [September 1, 2024, 9:31pm UTC](https://community.glideapps.com/t/how-to-fix-filter-with-multiple-yes-options-in-glide/76012/7 "2024-09-01T21:31:24Z")

</div>

Jeff, thanks for pointing it out, I got it.