Contact Report Opened Multiple Emails

[ccolahan]

I'm trying to create a report (e.g. smart list) identifying all the individual contacts who opened ALL of 6 emails sent. I used the below formula:

It seems that this smart list is actually pulling contacts who opened ANY of the 6 emails we sent. 

[Chris_Wilcox · Accepted solution]

You just need to write 6 separate filters for "opened email" and put 1 in each filter. Then make sure your filter rules is set to "All." 

Basically, when you add multiple options inside a smartlist filter like that, they are always used as a "OR." If you want to force it to be all, you have to add a separate filter for each occurrence.