Skip to main content
Question

Summary formula for Multi-Select Text

  • October 13, 2021
  • 0 replies
  • 80 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+22
  • Quickbase Alumni
  • October 13, 2021
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
------------------------------