Forum Discussion

AnnettaColeman's avatar
AnnettaColeman
Qrew Cadet
4 years ago

Seeking more elegant conditional formula against multi-select field

In our Project Management app we have a Multi-Select field to identify the various "Value Chain" teams that are impacted by the project.   This works as intended for notifications and dashboard views...
Formulas and functions
AnnettaColeman's avatar
AnnettaColeman
Qrew Cadet
4 years ago
Thank you!

------------------------------
Annetta Coleman
------------------------------
AnnettaColeman's avatar
AnnettaColeman
Qrew Cadet
4 years ago
Ok....  so now I want to checkbox if [Business Impacts] is either "Clinical" or a combination of both "Behavioral Health" and "Clinical" in a multi-select field...   I tried both of the following.   Neither worked....

  • If(ToText([Business Impacts])="Clinical" or ToText([Business Impacts])="Behavioral Health;Clinical", true)
  • If(ToText([Business Impacts])="Clinical" or
    ToText([Business Impacts])="Behavioral Health" and ToText([Business Impacts])="Clinical", true)

If I look at the field contents directly, the value is shown as "Behavioral Health;Clinical".   Why did my first If/Or not result in true?



------------------------------
Annetta Coleman
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    4 years ago
    The ToText of that field would have a separator of space ; space and not just a ;

    • If(ToText([Business Impacts])="Clinical" or ToText([Business Impacts])="Behavioral Health ; Clinical", true)

    Post back if that did not solve the issue.


    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------
    • AnnettaColeman's avatar
      AnnettaColeman
      Qrew Cadet
      4 years ago

      Yes!   Adding space before and after the semi colon worked.    Amazing what a bit of community feedback (and 4 hours of sleep) will do for one's perspective.   :)



      ------------------------------
      Annetta Coleman
      ------------------------------