Numerical Sorting

Smartsheet does not sort properly by numbers when you get above 9. Currently, it'll sort 1, 10, 11, 2, 3, 4, 5, 6, 7, 8, 9 rather than 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11 and the only way to fix it right now is by adding a character in front of the ones below 10.

Sign in to vote!

Find more posts tagged with

Idea Submitted

Enhancement Request

Comments

Jacob Cram

Within the sheet filter list the sorting is alphabetic and also numeric. However the numeric filtering does not properly consider two digit numbers properly. For example a list including numbers 1-10, 1 through 9 will be sorted properly but then 10 would be listed after 1 not after 9. Pretty easy fix here.

Screenshot 2023-02-18 200123.jpg

PeggyLang

@Jodi C I concur. I have a column with Store #'s. These are 4 digits. Store #'s that begin with a '0' fall under the last Store # with 4 digits. See screenshot below;

Would REALLY LOVE to have the column sort in the manner I expect. Ideas?

PM_Reeves

Is this still not resolved?

Surely this is an important feature.

Whether I have a prefix or not, it makes no difference to sorting by the specific column.

Jon R

This issue is creating a huge problem for me on a sheet I'm building. How can it be that Smartsheets can't recognize that 4 digit numbers are larger than 3 digit numbers? Here is sample data that was sorted ascending.

Quick Links

Trending ideas

Resource Management Plan Settings in Control Center - add Client and Project Code fields
In the Resource Management Plan Settings in Control Center, there is no way to link the Client and Project Code fields even though they are not Custom fields and part of the first 3 fields you enter when creating a new project. I can't select them in the Custom Resource Management Information Fields because they are not…
WorkApp Analytics
I’d like to see user analytics for WorkApps. I’ve checked the user report available in the Collaborator Pack, but it only shows how many times someone has clicked into the WorkApp each month. I’d like to know: Which resources (dashboards, sheets, forms, etc.) are getting the most traffic? Where are people spending their…
Sheet Icon Color Consistency
The 'Sheet' icon appears purple in the left navigation but blue within the sheet, creating inconsistency. Aligning icon colors across the platform would improve clarity and simplify user training. Please standardize the icon color to enhance user experience and reduce confusion during onboarding.