# A Little Filter Help
**URL:** https://community.glideapps.com/t/a-little-filter-help/23283
**Category:** Ask for Help
**Created:** [February 23, 2021, 12:09pm UTC](https://community.glideapps.com/t/a-little-filter-help/23283 "2021-02-23T12:09:53Z")
**Posts on this page:** 9
**Page:** 1
### Author:  [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)
#### Post date: [February 23, 2021, 12:09pm UTC](https://community.glideapps.com/t/a-little-filter-help/23283/1 "2021-02-23T12:09:53Z")
Hi!
I am trying to filter this inline list and can’t seem to get the results I want.
I would like to filter a sheet based on 2 columns. The row should be displayed if the end date is on or after today. A few rows do not have an end date, however, so these should be shown only when the available column does not equal 0. I added equals ‘blank’ for the rows which have an end date, but nothing filled in on the available column.
This is what I have setup currently:
See anything I’m doing wrong? Thank you!
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [February 23, 2021, 12:26pm UTC](https://community.glideapps.com/t/a-little-filter-help/23283/2 "2021-02-23T12:26:40Z")
Would Available is greater than 0 or End date is on or after today work?
---
### Author:  [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)
#### Post date: [February 23, 2021, 12:44pm UTC](https://community.glideapps.com/t/a-little-filter-help/23283/3 "2021-02-23T12:44:00Z")
No ☹ In both cases the old dated rows are showing up.
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [February 23, 2021, 12:46pm UTC](https://community.glideapps.com/t/a-little-filter-help/23283/4 "2021-02-23T12:46:09Z")
Which condition does the old rows satisfy?
---
### Author:  [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)
#### Post date: [February 23, 2021, 12:52pm UTC](https://community.glideapps.com/t/a-little-filter-help/23283/5 "2021-02-23T12:52:28Z")
Ahh Available is ‘blank’ …I removed that and it seems to work since I now have Available is greater and 0, so it actually knocks out the blank ones. Thanks!
---
### Author:  [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)
#### Post date: [February 23, 2021, 1:33pm UTC](https://community.glideapps.com/t/a-little-filter-help/23283/6 "2021-02-23T13:33:51Z")
OK, I want to also add another line list where it fits the above qualifications but also has ‘Yes’ in the exclusive column. Problem is everything has to be ‘OR’ or ‘AND’. You can’t combine them when filtering.
I’m looking for: Exclusive is ‘Yes’ **AND** Available is \> 0 **OR** End Date is on or after today
---
### Author:  [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)
#### Post date: [February 23, 2021, 11:36pm UTC](https://community.glideapps.com/t/a-little-filter-help/23283/7 "2021-02-23T23:36:37Z")
Anyone have an idea?
Thanks!
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [February 23, 2021, 11:49pm UTC](https://community.glideapps.com/t/a-little-filter-help/23283/8 "2021-02-23T23:49:57Z")
My thinking is you would have to create two if then else columns in the data.
- Available & End Date ITE:
If Available is \> 0 then True
If End Date is on or after Today then True
Else False
- Final ITE
If Exclusive is not Yes then False
If Available & End Date ITE is not True then False
Else True
---
### Author:  [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)
#### Post date: [February 24, 2021, 2:24pm UTC](https://community.glideapps.com/t/a-little-filter-help/23283/9 "2021-02-24T14:24:23Z")
Thank you Thinh!! That seems to work.