Counting blanks in a Contacts column

I'm trying to count the number of blank cells in a Contacts column in a remote sheet. Here's the formula:

=COUNTIF({SE-Onboarding Tracker - DM}, "")

The problem is ... it's returning a value of 30 when it should be 1. There's only 20 rows and only one of them doesn't have a Contact stored in the DM column. And yes I'm 100% sure there aren't any blank rows at the end of my sheet. Someone suggested I use this instead:

=COUNTIF({SE-Onboarding Tracker - DM}, "=")

That returns a value of 20 which is the number of rows including the one with the blank. Any suggestions?

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!