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: https://app.smartsheet.com/b/form/e69cfae30cc14c0ebc35f351bf9129a5
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"?
Help Article Resources
Check out the Formula Handbook template!