# Sort Inline list by number value **URL:** \ **Category:** Feature Requests\ **Created:** [October 2, 2019, 1:06am UTC](https://community.glideapps.com/t/sort-inline-list-by-number-value/807 "2019-10-02T01:06:55Z")\ **Posts on this page:** 14\ **Page:** 1
**Author:** ![mptpro](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mptpro/32/634_2.png) [@mptpro](https://community.glideapps.com/u/mptpro)\ **Post date:** [October 2, 2019, 1:06am UTC](https://community.glideapps.com/t/sort-inline-list-by-number-value/807/1 "2019-10-02T01:06:55Z")
Currently, the “Sort” function in Inline list sorts by alphanumeric list, and there is no option to sort via numbers. For example, this list: 3 5 2 1 14 24 Will be sorted as: 1 14 2 24 3 5 But, I would like the option to sort via numbers, so it will look like this: 1 2 3 5 14 24 ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [October 2, 2019, 3:12am UTC](https://community.glideapps.com/t/sort-inline-list-by-number-value/807/2 "2019-10-02T03:12:08Z")
You need to pad you numbers like this: =text(H3, “000000”). That way all of the numbers are the same length and will sort properly. ---
**Author:** ![mptpro](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mptpro/32/634_2.png) [@mptpro](https://community.glideapps.com/u/mptpro)\ **Post date:** [October 2, 2019, 3:32am UTC](https://community.glideapps.com/t/sort-inline-list-by-number-value/807/3 "2019-10-02T03:32:47Z")
Yeah I did that already. But I have a columns that work with this data so I had to create a separate columns which is a bit of a pain when the solution is very simple. ---
**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\ **Post date:** [October 2, 2019, 3:53am UTC](https://community.glideapps.com/t/sort-inline-list-by-number-value/807/4 "2019-10-02T03:53:00Z")
What is the simple solution you are referring to? ---
**Author:** ![mptpro](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mptpro/32/634_2.png) [@mptpro](https://community.glideapps.com/u/mptpro)\ **Post date:** [October 2, 2019, 4:27am UTC](https://community.glideapps.com/t/sort-inline-list-by-number-value/807/5 "2019-10-02T04:27:17Z")
The simple solution is to have an option on the “sort” function to sort via “number value”. This is similar to the update that glide made to the “filter” function to allow “empty” “is not”, “not empty” etc, whereas originally only had “is”. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [October 2, 2019, 4:28am UTC](https://community.glideapps.com/t/sort-inline-list-by-number-value/807/6 "2019-10-02T04:28:33Z")
I’m guessing it’s a little more complicated because I assume that glide treats all columns in the database as strings. To sort by number, all string values would have to be converted to decimal or integer values. Then there needs to be error handling if the value is not a valid number. Probably not too bad to program, but not completely cut and dried. ---
**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\ **Post date:** [October 2, 2019, 4:49am UTC](https://community.glideapps.com/t/sort-inline-list-by-number-value/807/7 "2019-10-02T04:49:53Z")
Numeric sort should actually work already as expected, we simply are using the wrong icon to show the sort direction ---
**Author:** ![mptpro](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mptpro/32/634_2.png) [@mptpro](https://community.glideapps.com/u/mptpro)\ **Post date:** [October 2, 2019, 5:09am UTC](https://community.glideapps.com/t/sort-inline-list-by-number-value/807/8 "2019-10-02T05:09:50Z")
@david what do you mean? It isn’t working for me. See the screenshot below. The column that is being sorted is “submitted” but you can see that it is not displayed in the correct order. You can see that it is sorting by character, not numeric value. (That’s why the “$95” is first, but the “$11,600” is last). ![Screenshot](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/1X/dc8059017f9f81a1f70f6e3c0f2cb8762fa9e80f.jpeg) ---
**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\ **Post date:** [October 2, 2019, 3:06pm UTC](https://community.glideapps.com/t/sort-inline-list-by-number-value/807/9 "2019-10-02T15:06:10Z")
Ah, I see. Yes, Glide does not understand currency values as numbers yet. If your column were formatted as a number (no currency symbol) then Glide could sort it. You can mirror your currency column with e.g. `={A2:A}` then format it as a simple number, then sort on that. ---
**Author:** ![mptpro](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mptpro/32/634_2.png) [@mptpro](https://community.glideapps.com/u/mptpro)\ **Post date:** [October 2, 2019, 9:15pm UTC](https://community.glideapps.com/t/sort-inline-list-by-number-value/807/10 "2019-10-02T21:15:46Z")
@david still doesn’t sort, even after changing the column to simple numbers. You can see in thescreenshot that they are simple numbers, not currency. ![38](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/1X/3e789d2a1196c31f9b5991efc3601b153d875d99.png) ---
**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\ **Post date:** [October 2, 2019, 9:35pm UTC](https://community.glideapps.com/t/sort-inline-list-by-number-value/807/11 "2019-10-02T21:35:13Z")
Would you mind sharing your app, please? ---
**Author:** ![mptpro](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mptpro/32/634_2.png) [@mptpro](https://community.glideapps.com/u/mptpro)\ **Post date:** [October 2, 2019, 9:51pm UTC](https://community.glideapps.com/t/sort-inline-list-by-number-value/807/12 "2019-10-02T21:51:54Z")
@Mark I just sent you a PM with link to the app ---
**Author:** ![Cisco\_Muratalla](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/cisco_muratalla/32/12358_2.png) [@Cisco\_Muratalla](https://community.glideapps.com/u/Cisco_Muratalla)\ **Post date:** [February 10, 2021, 9:23pm UTC](https://community.glideapps.com/t/sort-inline-list-by-number-value/807/13 "2021-02-10T21:23:43Z")
Perhaps feature request has been addressed, topic appears dormant, archived. ---
**Author:** ![Cisco\_Muratalla](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/cisco_muratalla/32/12358_2.png) [@Cisco\_Muratalla](https://community.glideapps.com/u/Cisco_Muratalla)\ **Post date:** [February 10, 2021, 9:23pm UTC](https://community.glideapps.com/t/sort-inline-list-by-number-value/807/14 "2021-02-10T21:23:47Z")