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
-
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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.
-
I don't think that would work because we can't access the email in a contact column.
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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
-
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
@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. 👍️👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!