Search on a text string to return all values

Hello My Fellow Smartsheet Gurus,

Is it possible to run a formula based on the text inputted in the column next to it to pull all possible values? I am trying to accommodate multiple ways of finding medication names where an exact match is not always possible? If so how would accomplish this?

Thanks so much in advance!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!