Conditionally Parsing Values from a Multi-select Cell

Michael Reis
Michael Reis ✭✭
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!