Count number of contacts
Options
Hi,
I need to find how many times a specific team member appears in multiple contacts cell. I understand that Contains doesn't work on this kind of cell so I tried HAS but I don't get the expected results.
=COUNTIFS(Lead:Lead, HAS(@cell, Team1))
Any idea?
Thanks
Best Answer

Another solution that worked for me;
=COUNTIFS(<Column Name>, FIND("<replace name>", @cell) > 0)
Thanks
Answers

Are both these columns Contact columns?
If yes, it should work using the HAS function as you've described.

Yes, both are Contacts. Doesn't work

Another solution that worked for me;
=COUNTIFS(<Column Name>, FIND("<replace name>", @cell) > 0)
Thanks
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!