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. We also have one use case where we need to target projects that affect only our "Clinical" value chain and no others. I currently have a formula checkbox that 'technically' works via a deeply nested IF statement, but is not very elegant.
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
------------------------------
