Is One Of (multiple contacts) field

palmcitytim ✭✭✭✭
edited 12/08/21 in Formulas and Functions

I have looked around and could not locate help for this question. I have a contacts field and it is configured to allow multiple people. How do I write an If statement to pick up a match to some other column having one of their names? Thanks much!

Best Answer

  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓

    Hi @palmcitytim

    If you're searching for one value within a multi-select cell, you can use the HAS function!

    For example, something like this:

    =COUNTIF({Multi Select Column}, HAS(@cell, [Single Name]@row))

    If this hasn't helped, it would be useful to see a screen capture of each sheet, identifying what you're looking to do, but please block out sensitive data.




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!