ChristieAnderso
3 years agoQrew Member
Summary formula for Multi-Select Text
Hello,
I am trying to create a summary report for selections made in a multi-select field. I'm using the formula -
------------------------------
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
------------------------------
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
------------------------------