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

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 @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

Answers

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Hi Martina,

    Unfortunately, as far as I know, it's not possible at the moment, but it's an excellent idea!

    Please submit an Enhancement Request when you have a moment

    I hope that helps!

    Be safe and have a fantastic week!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

    ✅Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    You would need to parse out the string so that each email was in it's own cell. Then you could generate your counts by using a COUNTIFS/FIND combo across the parsed cells.

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    @Paul Newcome

    I don't think that would work because we can't access the email in a contact column.

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    Ugh. Most of mine show up as emails because I don't really use the Contacts feature to add people. I forgot that contacts that have been stored show up as the name and not the email address.


    In that case a table would need to be built to pull the email address into a text/number column in place of the name after parsing out. THEN you could do your COUNT/FIND on the domain.


    It is a bit of a pain to set up, but at least it could potentially provide the desired results.

  • Thanks, everyone.

    I think I might need to just make two Assigned To columns for now. One for the client side and one for the 'us' side. Then just use countm to count the number of assignees for each of these columns.

    Thanks again for the help.

    Cheers

    Martina

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    @Martina Barnett

    You're more than welcome!

    Please help the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    @Martina Barnett That's a great idea actually! I was trying to think of a solution where you could have numerous different domains, but if you only have 2 different domains, that doesn't put too much on the users themselves and allows you to get your counts. 👍️👍️

Sign In or Register to comment.