Hello all, I am having an issue on a saved search where the project ID is not correctly descending or ascending. For example once our project numbers hit 1000+ the descending and ascending function seems to be broke. How can I fix this?

Try sorting by internal id

did not really work. For some reason it treats the projects in the 1000 range as if they were smallest number

It's sorting as a string, that's why. NetSuite has no idea that it has 2 components

how can i fix that?

Sort by date created?

Try creating a substring column removing the first 5 characters, cast to a number, then sort on that.

That's smart @Chris