+8How can I do a negative filter? Let's say I have a multiple select field with letters A-E. I can easily filter to show all records that contain all of D, E, and F. But I want to filter OUT all records that contain all of D, E, and F. Just D is fine, D and E is fine, etc.
Thanks for your help!
Best answer by Michael_Morris2
I meant “does not contain” or “has none of”. You can use groups to get more complicated filters.
I figured it out. My brain hurts trying to figure out why it works, but it works. I grouped: "has none of D or has none of E or has none of F." Thanks for talking me through it.
+8Depending on the field type use “contains” or “any of”.
Thanks Dan for the quick reply. I don't think that would work for my situation. I want to say "Don't use any record with ALL of D, E, and F."
Using "any of" would not allow for records with just D or just D and E.
Using "contains" I believe would have the same results unless I'm missing something.
+17Depending on the field type use “contains” or “any of”.
I meant “does not contain” or “has none of”. You can use groups to get more complicated filters.
+8I meant “does not contain” or “has none of”. You can use groups to get more complicated filters.
I figured it out. My brain hurts trying to figure out why it works, but it works. I grouped: "has none of D or has none of E or has none of F." Thanks for talking me through it.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
