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 -
IF(Contains($Selections, $SearchTerm),1,0) and am getting the error -
F...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendOK, just change the field type to formula numeric
If(Contains([Collaboration 1], "A1A warm-transfer: A1A Nurse Care Manager- Successful"),1,0)
+
If(Contains([Collaboration 1], "A1A warm-transfer: A1A Nurse Care Manager- Nurse not available; referral sent"),1,0)
This will result in a numeric value of 0 or 1 or 2, based on how many selections were made.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
If(Contains([Collaboration 1], "A1A warm-transfer: A1A Nurse Care Manager- Successful"),1,0)
+
If(Contains([Collaboration 1], "A1A warm-transfer: A1A Nurse Care Manager- Nurse not available; referral sent"),1,0)
This will result in a numeric value of 0 or 1 or 2, based on how many selections were made.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
Ok, confirming to change the field type for Collaboration 1 to formula numeric? Won't that remove the multi-select options for users? I may be misunderstanding this.
------------------------------
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
------------------------------
------------------------------
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
------------------------------
- MarkShnier__YouYikes no!
You have your multi select field called Collaboration 1. Then you would have a separate field which is formula numeric to count the number of selections in [Collaboration 1].
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------- Ok, I think I understand you here. Let me play with it and I'll reach back out if I get stuck again. Thank you!
------------------------------
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
------------------------------