@Mark Is this what I think it is???
is/isn’t included in works on text.
Oh…gotcha. So how does it differ than “includes/doesn’t include”?
Duh…of course. Nice.
So basically the same as contains /does not contain?
Way to go! Well done for figuring it out, oh and for creating a demo, as always thanks Robert
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!
Thanks @Robert_Petitto. You just solved my using AND with In-App filter problem.
Right. This is merely a filter—not a true inverse relation. I see what you mean.