I’m trying to sort a column with alphanumerical items and the sort is off. This has been a common issue in other recording software’s as well.
For example, an item which contains “10” will show up before an item which contains a “11” regardless of the actual number. So, “1025” will show up in the sort before “110” or “425”. This causes the sort to start (sometimes) with a seemly random number at the top of the column and the actual lowest number is somewhere buried in the middle.
Is there a way to sort based on the actual number?
Note that the number is automatically generated using the AutoID Column app.