Create formula text if multi-select text field contains a selection

  • 1
  • 2
  • Question
  • Updated 3 years ago
  • Answered
Trying to create a formula text field that says "Yes" or "No" if one selection in a multi-select text field is selected.

Right now I have this, but if more than one choice is selected (including the one I want), it shows no.

If(ToText([Multi-select Text])="Choice in Multi-select text","Yes","No")

Thinking that it might need a Contains operator, but can't figure it out.
Photo of Jared Leavitt

Jared Leavitt

  • 10 Points

Posted 3 years ago

  • 1
  • 2
Try this

If(Contains(ToText([Multi-select Text]),"Choice in Multi-select text"),"Yes","No")
Photo of Jared Leavitt

Jared Leavitt

  • 10 Points
...and I'm an idiot. Thanks Mark!
:). That's unlikely.
Photo of Jared Leavitt

Jared Leavitt

  • 10 Points
appreciate it...but I didn't even think of it.