Search for "Blank"

Options
Don Davis_16013
Don Davis_16013 Member Posts: 3
edited July 2022 in Sales CRM #1

I need to search for contacts that are missing an email but I do not see a condition to search for blank.  I have tried entering blank in quotes and have also tried leaving the cell open but that also does not work.  

Comments

  • Boris Tsibelman
    Boris Tsibelman Member Posts: 843
    5 Likes First Anniversary First Answer Combo Breaker
    edited October 2020 #2
    Options

    Try searching for "null"

  • Don Davis_16013
    Don Davis_16013 Member Posts: 3
    edited October 2020 #3
    Options

    I figured out, there is a way to search for empty fields.  

    Person, email is, Empty is the condition

     

    Thank you for your suggestion @Boris Tsibelman it drove me to go back and look again.