Formula to exclude blank cells


I have a formula set up to return a "yes" for all duplicate phone numbers and a "no" if not a duplicate, however, its pulling all blank rows as well and making my sheet look messy.

I need to exclude blank cells. My formula is:

=IF(COUNTIF(Phone:Phone, =Phone@row) > 1, "yes", "no")


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!