Auto-Numbers and using them to seach in smartsheet and pull up rows
Is there some nuance I'm missing with using auto-numbers to search in smartsheet?
I have a sheet with an auto-numbers column, and a form that's inputting data. Currently using auto-numbers in search isn't pulling up any results even though the ref used for the search is there in the sheet. This is the reference used SL100002 so no symbols that could potentially cause issues.
I'm looking for the most streamline way for rows to be pulled up using a search for the reference number by a team members using the smartsheet app on their phones, so that an additional box can be checked to complete a process by our internal team. We're estimating 50,000 as an approximate for total form submissions/rows, so there will be at least three sheets in total.
I have been also been looking at the use of QR codes for this process but haven't as yet found an effective method of auto-adding to each row and being able to do this on the scale needed.
Many thanks in advance for any help!