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

[Robert_Petitto]

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

An answer to:
I’m stumped. How to filter a multiple relation (inline list) by another multiple relation
?!

@Jeff_Hager

[Robert_Petitto]

Hm…if so…not yet…

[Mark]

is/isn’t included in works on text.

[Robert_Petitto]

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

[Mark]

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

[Robert_Petitto]

Duh…of course. Nice.

[Mr_Watkin]

So basically the same as contains /does not contain?

[Robert_Petitto]

Holy cow! I figured it out…not exactly an inverse relation but it got the job done!

[Rosewebstudio]

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

[Jeff_Hager]

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!

[S_C]

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

[Robert_Petitto]

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