# Sort option in Collection not working **URL:** \ **Category:** Ask for Help\ **Created:** [November 24, 2023, 1:32am UTC](https://community.glideapps.com/t/sort-option-in-collection-not-working/68088 "2023-11-24T01:32:21Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![weekang](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/weekang/32/66901_2.png) [@weekang](https://community.glideapps.com/u/weekang)\ **Post date:** [November 24, 2023, 1:32am UTC](https://community.glideapps.com/t/sort-option-in-collection-not-working/68088/1 "2023-11-24T01:32:21Z")
Hi, I created a very simple app to help with our invoicing. I set the collection to sort by balance owed in decreasing order But the sort is pretty bonkers as shown. Any ideas why? ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/a/caa4d658a5d1491d80adac5566b7084287f11bfa.jpeg) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/0/a0a2f208224d74c920db2da7fc5449f41e66ba03.jpeg) ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [November 24, 2023, 2:13am UTC](https://community.glideapps.com/t/sort-option-in-collection-not-working/68088/2 "2023-11-24T02:13:04Z")
Ya that $9900 is wrong. Where does this data live? Glide table? Google sheets? ---
**Author:** ![weekang](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/weekang/32/66901_2.png) [@weekang](https://community.glideapps.com/u/weekang)\ **Post date:** [November 24, 2023, 3:14am UTC](https://community.glideapps.com/t/sort-option-in-collection-not-working/68088/3 "2023-11-24T03:14:03Z")
Thanks for your reply Robert. Yeah it’s not just the 9900 but even more as below. And think I figured it out now… The balance owed column was a number formatted as currency in the Google sheet. Glide claims to read it in as a number but apparently still treats it as a string for sorting purposes. When I created a duplicate column in Sheets formatted as purely a number to sort on, it works fine now: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/1/6112ad2a58389d4e0ec73154dc66f1ad4c4cd54f.png) So is this a Glide bug? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [November 24, 2023, 3:32am UTC](https://community.glideapps.com/t/sort-option-in-collection-not-working/68088/4 "2023-11-24T03:32:07Z")
Try editing the column type in Glide and save it again. ---
**Author:** ![weekang](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/weekang/32/66901_2.png) [@weekang](https://community.glideapps.com/u/weekang)\ **Post date:** [November 24, 2023, 5:20am UTC](https://community.glideapps.com/t/sort-option-in-collection-not-working/68088/5 "2023-11-24T05:20:17Z")
Whoa that worked. Just edited and saved without changing anything… What manner of voodoo haha… Anyways thanks Darren! ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/9/5943128f313c4d02e0ff9a3fa72ed002979ed8bc.jpeg) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [November 24, 2023, 10:25am UTC](https://community.glideapps.com/t/sort-option-in-collection-not-working/68088/6 "2023-11-24T10:25:36Z")
Yeah, that happens a lot with Google Sheets. It’s good practice whenever you add a Google Sheet to go through all the columns one by one and set the column type. ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [December 1, 2023, 10:26am UTC](https://community.glideapps.com/t/sort-option-in-collection-not-working/68088/7 "2023-12-01T10:26:07Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.