Multiple Contact Cell in a COUNTIFS statement to only extract one name

Adrià Termes
Adrià Termes ✭✭✭
edited 09/06/23 in Formulas and Functions

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:

  1. {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).
  2. 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

  • Eric Law
    Eric Law ✭✭✭✭✭✭
    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))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!