Forum Discussion

ChristieAnderso's avatar
ChristieAnderso
Qrew Member
4 years ago

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...
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
4 years ago
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
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
4 years ago
OK, 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
------------------------------
  • ChristieAnderso's avatar
    ChristieAnderso
    Qrew Member
    4 years ago
    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
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      4 years ago
      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
      ------------------------------
      • ChristieAnderso's avatar
        ChristieAnderso
        Qrew Member
        4 years ago
        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
        ------------------------------