Countif Formula in Contact Column

I have created a summary sheet and one of my formulas is counting the number of times an email address appears in the column.

The formulas work when the column is "Text/Number" column, however, if I change it to a "Contact Column" the formula returns a 0 value which is not correct.

This is the formula (I have removed the email address for data protection reasons and replaced it with N/A). =COUNTIF([Chief Officer]:[Chief Officer], CONTAINS("N/A", @cell)).

It worked as a contact column previously, but decided to stop when I added new contacts to the list.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!