What is the Default data type for "auto-numbers"

JIM_AFO

I've created a "Client Database" using a sheet. We had 400+ rows of details input via an upload during the setup. Subsequent clients are added via a Form and the new client number is assigned via "auto number".

In our project portfolio sheets I am using a Index Match formula to pull client groups and client name instead of manually inputting those details across sheets. Essentially, staff should just input the Client number (referring to the client database number) and those details will auto-populate.

The formula has worked for all 400+ clients so far but when I try to reference this new client i get a "#No Match". Another thing I noticed, When sorting my client database via client number in ascending order the auto number client is 5100, and I have a client with number 9999. The client with 5100 always sorts to the last number and is listed after 9999 it should be listed before 9999.

Has anyone experienced this?

Mike TV

@JIM_AFO

For the #NO MATCH problem, please provide your formula and show in the sheet(s) where you should be getting a match.

For the sorting issue, please show the sheet with that column.

JIM_AFO

@Mike TV thanks for your reply. I've spent a significant amount of time with the Smartsheet team directly working on my issue and unfortunately there isn't an easy fix that can be achieved.