4 Replies Latest reply on Feb 2, 2016 12:37 PM by Grégoire Michel

    Advanced filters:

      Hello everyone -

       

      I am trying to pull a list but noticed some companies were included which I do not want. Below is a brief example of the smart list:

       

      Use Advanced filters: 1 and 2 and (3 or 4 or 5)

       

      Member of smart list: (in) All customers

      Member of smart list: (not in) Customers with service A

      Industry: (is) Healthcare

      Company Name: (contains) Hospital

      Email Address: (contains) Hospital

       

      The problem is, this is pulling up companies with either "Hospitality" in the company name and/or email address since "hospital" is in the word hospitality. However, I do not want to exclude ALL hospitality records since some are in the healthcare industry.

       

      How would I make sure that if the company/email address has hospitality, then I only get back the ones actually in the healthcare industry?

       

      Thanks in advance for the help!