Extract Value from Multi Select Option

Laura Zimmerman
edited 06/21/22 in Formulas and Functions

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!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!