create list based on a word


We have a contractor list that captures our contractors data from a form on our website. Here is the web address if you would like to take a look:

One of the cool features of this list is that it utilizes a multi-select dropdown menu. The challenge is actually finding and compiling information from the list. We would like to be able to pull specific line/row items based on a single word. For instance: I am looking for a roofing contractor; is there a report or way to pull contractor information based on the word "roof"?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!