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