# "Is / Isn't Included In" Filter?!

**URL:** <https://community.glideapps.com/t/is-isnt-included-in-filter/14289>\
**Category:** Ask for Help\
**Created:** [August 21, 2020, 2:26am UTC](https://community.glideapps.com/t/is-isnt-included-in-filter/14289 "2020-08-21T02:26:33Z")\
**Posts on this page:** 12\
**Page:** 1

<div class="post-metadata">

**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:** [August 21, 2020, 2:26am UTC](https://community.glideapps.com/t/is-isnt-included-in-filter/14289/1 "2020-08-21T02:26:33Z")

</div>

## @Mark Is this what I think it is???

![Screen Shot 2020-08-20 at 10.24.31 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/9/9e6ad5a3ac2d1a08ac85b8432f6633092439b6cf.png)

An answer to:  
[I’m stumped. How to filter a multiple relation (inline list) by another multiple relation](https://community.glideapps.com/t/im-stumped-how-to-filter-a-multiple-relation-inline-list-by-another-multiple-relation/14120)  
?! 🙏

@Jeff_Hager

---

<div class="post-metadata">

**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:** [August 21, 2020, 2:41am UTC](https://community.glideapps.com/t/is-isnt-included-in-filter/14289/2 "2020-08-21T02:41:35Z")

</div>

Hm…if so…not yet…

 ![Screen Shot 2020-08-20 at 10.39.36 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/7/7becb23568272d91aba63eade557eb8a7327fabe.jpeg)

---

<div class="post-metadata">

**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\
**Post date:** [August 21, 2020, 3:27am UTC](https://community.glideapps.com/t/is-isnt-included-in-filter/14289/3 "2020-08-21T03:27:16Z")

</div>

is/isn’t included in works on text.

---

<div class="post-metadata">

**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:** [August 21, 2020, 3:28am UTC](https://community.glideapps.com/t/is-isnt-included-in-filter/14289/4 "2020-08-21T03:28:43Z")

</div>

Oh…gotcha. So how does it differ than “includes/doesn’t include”?

---

<div class="post-metadata">

**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\
**Post date:** [August 21, 2020, 3:29am UTC](https://community.glideapps.com/t/is-isnt-included-in-filter/14289/5 "2020-08-21T03:29:40Z")

</div>

- “Robert Petitto” includes “Robert”
- “Robert” is included in “Robert Petitto”

---

<div class="post-metadata">

**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:** [August 21, 2020, 3:31am UTC](https://community.glideapps.com/t/is-isnt-included-in-filter/14289/6 "2020-08-21T03:31:57Z")

</div>

Duh…of course. Nice.

---

<div class="post-metadata">

**Author:** ![Mr\_Watkin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mr_watkin/32/349_2.png) [@Mr\_Watkin](https://community.glideapps.com/u/Mr_Watkin)\
**Post date:** [August 21, 2020, 7:44pm UTC](https://community.glideapps.com/t/is-isnt-included-in-filter/14289/7 "2020-08-21T19:44:44Z")

</div>

So basically the same as contains /does not contain?

---

<div class="post-metadata">

**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:** [August 21, 2020, 7:49pm UTC](https://community.glideapps.com/t/is-isnt-included-in-filter/14289/8 "2020-08-21T19:49:58Z")

</div>

Holy cow! I figured it out…not exactly an inverse relation but it got the job done!  
https://www.loom.com/embed/3f53a83650be4420818037b42e1b3783

 ![WAMS_Lunch_App_·Glide·_Create_Apps_from_Google_Sheets](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/8/80afbddf46c55025322d6de97ccea72b2f19aab4.png)

---

<div class="post-metadata">

**Author:** ![Rosewebstudio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rosewebstudio/32/12261_2.png) [@Rosewebstudio](https://community.glideapps.com/u/Rosewebstudio)\
**Post date:** [August 21, 2020, 8:28pm UTC](https://community.glideapps.com/t/is-isnt-included-in-filter/14289/9 "2020-08-21T20:28:20Z")

</div>

Way to go! Well done for figuring it out, oh and for creating a demo, as always thanks Robert

---

<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:** [August 21, 2020, 8:43pm UTC](https://community.glideapps.com/t/is-isnt-included-in-filter/14289/10 "2020-08-21T20:43:26Z")

</div>

Nice catch! I’ll have to remember that one.

I don’t think that would help me in my case where I need a relation to find any rows in the related sheet with a date prior to the current date in the row establishing the relation. In my case it’s not an inversion, because I want to exclude any current and future dates from the relation so I can perform a rollup sum on only those rows with a date prior to the current date.

However, as an inversion, this is definitely something that would work. Again, nice work!

---

<div class="post-metadata">

**Author:** ![S\_C](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/s_c/32/12766_2.png) [@S\_C](https://community.glideapps.com/u/S_C)\
**Post date:** [August 21, 2020, 9:02pm UTC](https://community.glideapps.com/t/is-isnt-included-in-filter/14289/11 "2020-08-21T21:02:09Z")

</div>

Thanks @Robert_Petitto. You just solved my using AND with In-App filter problem.

---

<div class="post-metadata">

**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:** [August 21, 2020, 9:36pm UTC](https://community.glideapps.com/t/is-isnt-included-in-filter/14289/12 "2020-08-21T21:36:24Z")

</div>

Right. This is merely a filter—not a true inverse relation. I see what you mean.
