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

Attachments in Cells
I rely heavily on Smartsheet’s Document Generation. However, this workflow is currently dependent on having photos stored inside cells, since row attachments alone cannot be used directly in document generation.. If Smartsheet allowed attachments to be displayed as thumbnails in cells (as a reference), document generation…
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…
Form Upgrade to Pull In Data from Another Smartsheet Source
It would be extremely helpful if there was a way to have data pull into a form from another Smartsheet source based on selections made within the form. Example: On the form there is a dropdown to select a client property number. The property Name, Address, and any additional property information are then pulled into the…