Counting people with the same email domain in a multiselect assigned to cell


Hi there

I have a multiselect Assigned To column linked to a contact list. So the contacts are displayed with their full names. Email addresses are shown in the hover over menu for each contact as per usual.

I want to count how many of the contacts in the cell belong to the same company. I.e. have the same email domain. In this case

I've tried =COUNTM([Assigned To]@row) to confirm that I get the full count right.

I've also tried FIND inside a COUNT function. As well as inside COUNTIFS. I even tried a COLLECT, but they're not giving me the answer I want.

Any suggestions?




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!