Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

Conditionally Parsing Values from a Multi-select Cell

✭✭
edited 06/21/23 in Formulas and Functions

Hi!

I am trying to create a column formula that pulls only multi-select values which contain the string "ML" from a multi-select column.


Here is example output that I am looking for:

In this case, "Templates Used" contains the full list, while "Mini Lesson Templates" should only include values from "Templates Used" which contain the string "ML"


Appreciate your assistance in advance!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions