Forum Discussion

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

MarkShnier__You

Icon for Qrew Legend rank

Qrew Legend

4 years ago

ToText([Business Impacts]) = "Clinical"

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

Qrew Cadet

4 years ago

Thank you!

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

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