Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Search using wildcard* not locating content in a sheet
Today a user asked how to make the searches in a sheet less restrictive. I offered the wildcard as a solution and as we were walking through the search it found 0 results.
Within the sheet I have a column with a customer part numbers including revision example: 111-111111_RevA. I perform a search for the part number 111-111111* because I want to search for the part and find all revisions. Instead, I get 0 results.
This behavior is 100% not as expected, nor how it works on nearly every program or application in use in decades. If I cannot rely on the built in search then users would have to export and search within other applications (Excel) to perform basic (and reliable) searches adding additional steps to the process.
This seems like a large oversight which makes me believe I am overlooking something. I tried ctrl-F and obtained the same result. 0 results. Anyone have any ideas?