AnsweredAssumed Answered

And vs. or filters in smart lists for "not in" fields

Question asked by 3757bffac482ddc856f83a5390b55ff5767b91a8 on Nov 26, 2016
Latest reply on Dec 1, 2016 by Dayna Wellman

I'm setting up a smart list that is trying to pull anyone who is in list A but "not in" smart list list B or C, and I'm applying "or" filters between B & C. In my logic I would say 1 and (2 or 3). However, when I run it, it's not excluding the leads properly -- I'm getting tied up in the "not in"/negative logic. Has anyone else encountered this scenario? Is "and" the right way to go instead of or -- why? I would think it needs to be "or" because I'm trying to pull anyone who matches any of these "not in" criteria, not matching all of the criteria.