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 @wencomine.com.
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?
Cheers
Martina