Skip to main content
Question

Summary formula for Multi-Select Text

  • October 13, 2021
  • 0 replies
  • 82 views

Hello,

I am trying to create a summary report for selections made in a multi-select field.  I'm using the formula -


IF(Contains($Selections, $SearchTerm),1,0)

and am getting the error - 

Formula error
Expecting text but found number

My actual text is here:
If(Contains([Collaboration 1], "A1A warm-transfer: A1A Nurse Care Manager- Successful"),1,
If(Contains([Collaboration 1], "A1A warm-transfer: A1A Nurse Care Manager- Nurse not available; referral sent"),1,0))

I found a conversation in the community with a similar error, but there was no resolution posted so I'm stuck.  Any help is appreciated!  




------------------------------
Christie Anderson, PMP She.Her.Hers. | Proactive Care Management Associate, Aetna One Advocate
p 959-230-7059
6005 Nacot Pl, Mail Code F488, New Albany, OH, 43054
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
Is the result of your formula supposed to be the number of selections?  Can you give an example of what your day looks like and the response that you expect?

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------