COUNTIF Formula for Contact Column

Hello Community,

I have a formula setup to count the number of times a contact is mentioned in another sheet, but it is not counting the rows with multiple contacts in the cell.

Is there any way we can workaround this to count every time the contact is mentioned, even when it's multiple contacts in a cell?

My current formula is this: =COUNTIF({contact}, [Name(Contact)]@row)

Please let me know if you have any questions. I am hoping this is an easy fix.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!