Multiple Contact Cell in a COUNTIFS statement to only extract one name
Hi all.
I have been browsing the community for some time, but have been unable to find a solution to this issue. I have been trying to count a specific name from a multiple contact column, but calculations are not capturing the right number. I have tried two different approaches:
- {E2E Framework Solutions Funnel Range 21}, FIND($[Metric NAme]@row, @cell) > 0) In this formula, I try to use the written name in Metric NAme in each row to see in the Range 21 (the multiple contact column) if we have it in there (with FIND, if superior to 0, it should mean we can capture it).
- Same as above, but creating a helper column with a string (by adding + "") so that we can easily find if such name appears. It doesn't work either,
Does anybody have a quick tip on solving such issue? Do you think I need to create a helper column to check by person if it appears in the contact cell with a CONTAIN? Would really appreciate your help!
Best Answer
-
@Adrià Termes I would use either a helper sheet or the summary tab
=COUNTIF({E2E Framework Solutions Funnel Range 21}, CONTAINS(*use the name in quotes for summary tab or reference a name in a row if using summary sheet*,@cell))
Answers
-
@Adrià Termes I would use either a helper sheet or the summary tab
=COUNTIF({E2E Framework Solutions Funnel Range 21}, CONTAINS(*use the name in quotes for summary tab or reference a name in a row if using summary sheet*,@cell))
-
Yes, it works Eric!
Very probably I had issues with monstruous formulas. Separating into chunks can usually help.
Thank you very much!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!