Extract Value from Multi Select Option

Laura Zimmerman

Hello! I'm struggling on executing a formula to return one of the values from a multi select column I have.

I don't want to count the values, but rather have the formula pull out the specific value. I have a column called Internal Analysis Activities and it has two options to choose from A. Existing Opportunity or B. Baseline Opportunity.

What do you recommend for having the helper column list out option A or B and corresponding detail.

Any help appreciated!

Paul Newcome

Is it possible to have both A and B selected in the same cell a the same time?

Laura Zimmerman

Yes and that was a challenge I ran into not being able to use a FIND or LEFT/RIGHT function. The values can have one or both options selected.

Paul Newcome

What kind of additional data would you want displayed and how would you want it displayed?

Try a formula like this...

=IF(HAS([Multi-Select Column Name]@row, "Option A"), "Additional Text For Option A") + " " + IF(HAS([Multi-Select Column Name]@row, "Option B"), "Additional Text For Option B")