# Filters **URL:** \ **Category:** Ask for Help\ **Created:** [March 12, 2023, 5:14pm UTC](https://community.glideapps.com/t/filters/59054 "2023-03-12T17:14:09Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![geordiep](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/geordiep/32/5586_2.png) [@geordiep](https://community.glideapps.com/u/geordiep)\ **Post date:** [March 12, 2023, 5:14pm UTC](https://community.glideapps.com/t/filters/59054/1 "2023-03-12T17:14:09Z")
iv set up a filter to let me know whats completed / in progress and the completed shows true and the in progress saying false, am i missing something. ![Screenshot 2023-03-12 5.13.15 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/e/fef4d89e59ba54b1f34760d4856d444b6b600fb8.png) ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [March 12, 2023, 5:18pm UTC](https://community.glideapps.com/t/filters/59054/2 "2023-03-12T17:18:01Z")
You must be pointing your filter field to a Boolean column. If you want different values based off of that true/false, better to create an if then else column, create conditions that output a more readable word choice based off of the true false, call it filter, and use that as the filter for that collection. ---
**Author:** ![geordiep](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/geordiep/32/5586_2.png) [@geordiep](https://community.glideapps.com/u/geordiep)\ **Post date:** [March 14, 2023, 7:40pm UTC](https://community.glideapps.com/t/filters/59054/3 "2023-03-14T19:40:49Z")
still not getting to do what i want ![Screenshot 2023-03-14 7.38.13 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/3/0353f1fdf368a6b98fd12eaf665eb434bc6d2102.png) ---
**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 14, 2023, 7:52pm UTC](https://community.glideapps.com/t/filters/59054/4 "2023-03-14T19:52:57Z")
Don’t forget that boolean columns can be true, false, or blank. That’s 3 different values. I recommend an IF column that returns true if your boolean is true, else return false. The else will include all false and blank values. Your filter should should use the IF column instead of the boolean column. Better yet, change your IF column to return Completed or In Progress instead of true or false. Seems like that would be a lot more intuitive to the user. Basically exactly what @Robert_Petitto said above. ---
**Author:** ![geordiep](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/geordiep/32/5586_2.png) [@geordiep](https://community.glideapps.com/u/geordiep)\ **Post date:** [March 16, 2023, 9:49pm UTC](https://community.glideapps.com/t/filters/59054/5 "2023-03-16T21:49:54Z")
Im still getting true false showing ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [March 16, 2023, 9:59pm UTC](https://community.glideapps.com/t/filters/59054/6 "2023-03-16T21:59:06Z")
Did you change your if-else to show false if empty? And set your filter to that if else column? ---
**Author:** ![geordiep](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/geordiep/32/5586_2.png) [@geordiep](https://community.glideapps.com/u/geordiep)\ **Post date:** [March 16, 2023, 10:04pm UTC](https://community.glideapps.com/t/filters/59054/7 "2023-03-16T22:04:32Z")
that does not show in filter data options. ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [March 16, 2023, 10:06pm UTC](https://community.glideapps.com/t/filters/59054/8 "2023-03-16T22:06:17Z")
It should… maybe you are not on the same sheet… or do you have a row owner there? ---
**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 16, 2023, 10:08pm UTC](https://community.glideapps.com/t/filters/59054/9 "2023-03-16T22:08:22Z")
Screenshots of your IF column configuration and available columns for the in app filter configuration, please. ---
**Author:** ![geordiep](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/geordiep/32/5586_2.png) [@geordiep](https://community.glideapps.com/u/geordiep)\ **Post date:** [March 16, 2023, 10:11pm UTC](https://community.glideapps.com/t/filters/59054/10 "2023-03-16T22:11:42Z")
![Screenshot 2023-03-16 10.10.08 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/1/716153c04ae849c9a43d024d246218316223261b.png) ![Screenshot 2023-03-16 10.11.24 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/d/0d07258a5c6d8593c82196930611f1dfe395dd6a.png) ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [March 16, 2023, 10:12pm UTC](https://community.glideapps.com/t/filters/59054/11 "2023-03-16T22:12:50Z")
Where is the if-else column? add one on the right side of the boolean column ---
**Author:** ![geordiep](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/geordiep/32/5586_2.png) [@geordiep](https://community.glideapps.com/u/geordiep)\ **Post date:** [March 16, 2023, 10:16pm UTC](https://community.glideapps.com/t/filters/59054/12 "2023-03-16T22:16:48Z")
![Screenshot 2023-03-16 10.16.25 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/e/9e3285ead293cccb1e8c2d4cfc09a1f054d51a3e.png) like that?. ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [March 16, 2023, 10:17pm UTC](https://community.glideapps.com/t/filters/59054/13 "2023-03-16T22:17:17Z")
This is not an if-else column… delete that one, and add new if-else ![Screen Shot 2023-03-16 at 6.20.42 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/b/1bc436d26e799ec6beb415ef0e19a7e0d118ac7e.png) ---
**Author:** ![geordiep](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/geordiep/32/5586_2.png) [@geordiep](https://community.glideapps.com/u/geordiep)\ **Post date:** [March 16, 2023, 10:29pm UTC](https://community.glideapps.com/t/filters/59054/14 "2023-03-16T22:29:29Z")
cant delete it in data sheet. ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [March 16, 2023, 10:30pm UTC](https://community.glideapps.com/t/filters/59054/15 "2023-03-16T22:30:22Z")
Oh… it is in Google Sheets… delete it later in google… add a new one in Glide. Click on your technician complete column and choose to add a column on the right… and select if-then-else ![Screen Shot 2023-03-16 at 6.44.03 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/a/bab3b7b136f9c1d72a8fa5da2e507f2e10b81eac.png) ![Screen Shot 2023-03-16 at 6.44.18 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/a/ca0b89fa125cd45a02ad6ec73075ea3502971e69.png) ---
**Author:** ![geordiep](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/geordiep/32/5586_2.png) [@geordiep](https://community.glideapps.com/u/geordiep)\ **Post date:** [March 16, 2023, 10:46pm UTC](https://community.glideapps.com/t/filters/59054/16 "2023-03-16T22:46:20Z")
thank you ---
**Author:** ![geordiep](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/geordiep/32/5586_2.png) [@geordiep](https://community.glideapps.com/u/geordiep)\ **Post date:** [March 16, 2023, 11:10pm UTC](https://community.glideapps.com/t/filters/59054/17 "2023-03-16T23:10:50Z")
![Screenshot 2023-03-16 11.09.22 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/5/55e5ebda3f070743dec3a1c0d8a542795a9a2d99.png) what is this know i get one step and 6 back very frustrating. ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [March 16, 2023, 11:18pm UTC](https://community.glideapps.com/t/filters/59054/18 "2023-03-16T23:18:04Z")
You set tab visibility condition… remove it ---
**Author:** ![geordiep](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/geordiep/32/5586_2.png) [@geordiep](https://community.glideapps.com/u/geordiep)\ **Post date:** [March 17, 2023, 9:16pm UTC](https://community.glideapps.com/t/filters/59054/19 "2023-03-17T21:16:54Z")
can i apply multiple filter as to just one, i tried the same as what you told me and so i tried another IF but didnt work, so at moment iv got completed in my filter. ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [March 17, 2023, 9:56pm UTC](https://community.glideapps.com/t/filters/59054/20 "2023-03-17T21:56:09Z")
You would have to show the workflow… but yes, you can apply multiple filters [Next page](https://community.glideapps.com/t/filters/59054.md?page=2)