Sorting Rows Ascending Numerically

I right click on the column and select "Sort Rows" and select "Sort Items By" the name of the column. They arrange numerically but it's broken up into numbers 007-099 showing up below 103-180. I want the 007-099 numbers to show up above 103-180 (as it should).

My thought is that the numbers are "text"? But I can't find where to assign the type of content in the cell.

Any help would be appreciated!

Find more posts tagged with

Comments

Paul Newcome

You are correct in that they are being read as text. You will need to create a hidden helper column with the following in it:

=VALUE([Original Number Column]@row)

This will convert it to an actual number (which will remove the leading zeroes), and you would then sort by that helper column.

RainbowMoonbeams

Paul, thank you for your reply.

I need to keep the leading 0's in there because they are part of the information that is stored in that column. Do you think they will still affect the way they after sorting after creating the hidden column?

In your formula, do I replace "Original Number Column" with the column name?

Paul Newcome

The leading zeroes will remain in the original column. They just won't be there in the Helper column.

You would sort based on the hidden helper column, so the data will remain intact in the original column.

"Original Number Column" would be replaced with the column name housing the numbers that contain the leading zeroes.

RainbowMoonbeams

Oh, I see! That is an interesting concept.

Thank you! I will try that.

Paul Newcome

Happy to help!

Whenever I have a column like this specifically for sorting, I will move it to the far left of the sheet and then hide it. You won't see it when looking at the sheet itself, but when you go to sort, it will be the very first column on the list. I also name it something like "Sorting Column" or something along those lines so it is obvious that's which column I want to sort by.

Sign in to join the conversation!

Quick Links

Trending discussions

Notifications Currently Experiencing Issues?
Hi All, I seem to be having a bunch of notification issues, and I'm wondering if anyone else is experiencing issues. Please keep in mind I have had these automations in place for over 2 years already & they always worked as expected. Is this a system-wide issue, or should I connect with Smartsheet Support? Issue 1 -…
Dashboard % are not matching
Hi! I have a Dashboard feeding off pretty simple raw data. It's mainly detailing this is how many accounts we think we'll get, this is how many we've gotten and then provides a %. I wanted to add a chart just to pretty it up a bit but now the % done is reporting differently and I have no clue why. Here is the raw data: The…
New user; How to sort and format data by date
Hi! New user here. We have a basic sheet to track dates, hotel reservations, and the project. How can I format all dates to be uniform? My goal is to be able to sort by date or amount. Currently, we may have one date entry as 08/25/25 and another as 1/12/25. This really affects sorting.