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 LegendIs 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__YouQrew 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
------------------------------