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!