Forum Discussion

Qrew Cadet

3 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

MarkShnier__You

Icon for Qrew Legend rank

Qrew Legend

3 years ago

ToText([Business Impacts]) = "Clinical"

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

AnnettaColeman
Qrew Cadet
3 years ago
Thank you!

------------------------------
Annetta Coleman
------------------------------
- AnnettaColeman
  Qrew Cadet
  3 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
    Qrew Legend
    3 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
    ------------------------------