Search for "Blank"

Don Davis_16013

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.  

Boris Tsibelman

Try searching for "null"

Don Davis_16013

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.