# Sort rows in sheet **URL:** \ **Category:** Ask for Help\ **Created:** [February 13, 2023, 10:46am UTC](https://community.glideapps.com/t/sort-rows-in-sheet/57881 "2023-02-13T10:46:39Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![JCM](https://avatars.discourse-cdn.com/v4/letter/j/58f4c7/32.png) [@JCM](https://community.glideapps.com/u/JCM)\ **Post date:** [February 13, 2023, 10:46am UTC](https://community.glideapps.com/t/sort-rows-in-sheet/57881/1 "2023-02-13T10:46:39Z")
Need to sort rows in sheet (table). For example sort by item id, but in the sheet. If you add new rows, you cant sort them by column ---
**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:** [February 13, 2023, 12:11pm UTC](https://community.glideapps.com/t/sort-rows-in-sheet/57881/2 "2023-02-13T12:11:27Z")
What’s the purpose of needing data to be sorted in the table itself? ---
**Author:** ![JCM](https://avatars.discourse-cdn.com/v4/letter/j/58f4c7/32.png) [@JCM](https://community.glideapps.com/u/JCM)\ **Post date:** [February 13, 2023, 2:08pm UTC](https://community.glideapps.com/t/sort-rows-in-sheet/57881/3 "2023-02-13T14:08:09Z")
Just imagine 2400 items, 2400 rows originally sort by item id. **ART** **ITEM ID** **ITEM** 01000 ITEM 1 01001 ITEM 2 01010 ITEM 3 01011 ITEM 4 01050 ITEM 5 01051 ITEM 998 01055 ITEM 999 02300 ITEM 2300 02400 ITEM 2400 Every week i have to add ítems and erase ítems. I add row but it goes to the last record. After several weeks y don´t remember if one item has been added or not. If the item id column were able to be sorted from A-Z ascending order, it would be very easy to know if one item id is repeated or not. Otherwise i am completely lost. I use Glide tables, not Google sheets Sorting a column should be a basic opcion in Glidde thanks ---
**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\ **Post date:** [February 13, 2023, 2:24pm UTC](https://community.glideapps.com/t/sort-rows-in-sheet/57881/4 "2023-02-13T14:24:23Z")
The idea is that the data editor is made to store and process data. The layout editor displays the data including filtering and sorting it. I’m not a developer, and I discovered this when I started Glide, and at the beginning, I too felt like sorting. I’ve grown to like that the table is raw untouched data. In Google Sheets, to do things neatly, really one tab should be your raw data, then in a second tab, you would duplicate your raw data and filter and sort the data. But most don’t do that and filter/sort on the raw data, which denatures the table and to me feels quite uncomfortable. I guess it’s a question of what one is accustomed to. If really you want to sort ItemIDs in the data editor, you can. Create a lookup column that looks up your ItemIDs (the result will be a column of arrays), sort this array with the Sort Array column, and pick elements one by one from the sorted array by using a Single Value column. Notice how the Name column is now sorted in the NameAscending column. **Your table could look similar to the following** ![Screenshot 2023-02-13 at 15.33.45](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/4/848a7e888669577b97f9b7b82b3e48a44148ebb7.jpeg) **Configuration of RowIndex** ![Screenshot 2023-02-13 at 15.35.37](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/7/67e7b25b998d8c47a767cd20e06550add38c3c3f.png) **Configuration of NameAscending** ![Screenshot 2023-02-13 at 15.34.35](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/c/3c73993f06e8223543c3b399f3f0b1f3ad4b64b0.png) ---
**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:** [February 13, 2023, 8:34pm UTC](https://community.glideapps.com/t/sort-rows-in-sheet/57881/5 "2023-02-13T20:34:32Z")
I agree with @nathanaelb. There shouldn’t be much of a reason to sort the data in the table, because it is raw data. Glide has all kinds of sorting options on the front end. If you are building an app to work with this data, then your app front end should be doing the sorting, filtering, adding, editing, and deleting rows. Really, the only time you would have to worry about the table is when you are actively developing the app. ---
**Author:** ![JCM](https://avatars.discourse-cdn.com/v4/letter/j/58f4c7/32.png) [@JCM](https://community.glideapps.com/u/JCM)\ **Post date:** [February 14, 2023, 8:36am UTC](https://community.glideapps.com/t/sort-rows-in-sheet/57881/6 "2023-02-14T08:36:35Z")
Sorting columns is a basic option in any software that works with tables. I see this problem in several forums and if at the programming level it is not difficult for you, you should implement this option urgently and you would improve the satisfaction of your customers. the solutions you propose are detours to fix something that should be much simpler thanks ---
**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\ **Post date:** [February 14, 2023, 6:13pm UTC](https://community.glideapps.com/t/sort-rows-in-sheet/57881/7 "2023-02-14T18:13:54Z")
I wish we could build applications with dummy data in the data editor, without ever seeing the application’s real user data. So in my view, in an ideal world, the data editor would be necessary to build data logic, not to actually view data. The data would be viewed in the layout editor or in the live version _by those who have the right_ to view the data. Based on this, sorting data in the data editor would be useless. My request therefore to Glide: don’t allow us to sort data in the data editor, instead hide user data so developers can’t see it.