Seeking more elegant conditional formula against multi-select field

Question

In our Project Management app we have a Multi-Select field to identify the various "Value Chain" teams that are impacted by the project.&nbsp; &nbsp;This works as intended for notifications and dashboard views.&nbsp; We also have one use case where we need to target projects that affect only our "Clinical" value chain and no others.&nbsp; &nbsp; I currently have a formula checkbox that 'technically' works via a deeply nested IF statement, but is not very elegant.&nbsp; &nbsp;
I am seeking a more elegant conditional statement for my formula checkbox that basically says 'If Clinical is the ONLY value selected in BUSINESS IMPACTS (a multi-select field) then this formula checkbox is checked'.How would you code this?------------------------------Annetta Coleman------------------------------

markshnier__you · Answer

ToText([Business Impacts]) = "Clinical"------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

annettacoleman · Answer

Thank you!------------------------------Annetta Coleman------------------------------

annettacoleman · Answer

Ok....&nbsp; 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...&nbsp; &nbsp;I tried both of the following.&nbsp; &nbsp;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".&nbsp; &nbsp;Why did my first If/Or not result in true?------------------------------Annetta Coleman------------------------------

markshnier__you · Answer

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

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

Forum Discussion

Seeking more elegant conditional formula against multi-select field

5 Replies