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 2a46e3af07f50f038780d3d1a2824d043c418147

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.

 

mrketo.png

Outcomes