Forum Discussion
MarkShnier__You
Qrew Legend
4 years agoIs 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
------------------------------
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
MarkShnier__You
Qrew Legend
4 years agoOK, 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
------------------------------
- ChristieAnderso4 years agoQrew MemberOk, 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
------------------------------- MarkShnier__You4 years ago
Qrew Legend
Yikes 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
------------------------------- ChristieAnderso4 years agoQrew MemberOk, 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
------------------------------