Conditionally Parsing Values from a Multi-select Cell

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


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!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!