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.
