# Please Fix Currency Filter/Sorting on pages!

**URL:** <https://community.glideapps.com/t/please-fix-currency-filter-sorting-on-pages/62192>\
**Category:** Report a Bug\
**Created:** [May 27, 2023, 1:53pm UTC](https://community.glideapps.com/t/please-fix-currency-filter-sorting-on-pages/62192 "2023-05-27T13:53:28Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![HouseHippo](https://avatars.discourse-cdn.com/v4/letter/h/6f9a4e/32.png) [@HouseHippo](https://community.glideapps.com/u/HouseHippo)\
**Post date:** [May 27, 2023, 1:53pm UTC](https://community.glideapps.com/t/please-fix-currency-filter-sorting-on-pages/62192/1 "2023-05-27T13:53:28Z")

</div>

Currencies in lists are totally broken guys. Since there’s no “Currency” column in data tables, I’m left using a “text” column. (I can’t use “number” column since the currency symbol is removed). This causes a cascade of issues.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/9/c91b1595c7eb564955c40b426a423f8148320bf0.jpeg)

FILTERING: I can’t filter by less than/greater than, because the filter options for text columns don’t include it. Only number columns do.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/4/c49e55cdac83b50c3d7a0f0fe85d1e04f8879379.png)

SORTING: Pay close attention to the picture. Numbers are being incorrectly sorted by FIRST DIGIT ascending, not ACTUAL SIZE ascending. IE, $1000 is not a larger number than $44. So the sort order is entirely wrong.

Please solve.

---

<div class="post-metadata">

**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\
**Post date:** [May 27, 2023, 2:02pm UTC](https://community.glideapps.com/t/please-fix-currency-filter-sorting-on-pages/62192/2 "2023-05-27T14:02:59Z")

</div>

If you are using a text column then that sort order looks correct. For a numeric sort you could use a math column… price\*1… then sort that

---

<div class="post-metadata">

**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:** [May 27, 2023, 2:03pm UTC](https://community.glideapps.com/t/please-fix-currency-filter-sorting-on-pages/62192/3 "2023-05-27T14:03:59Z")

</div>

> [@HouseHippo](#):
>
> (I can’t use “number” column since the currency symbol is removed).

Works for me 🤷‍♂️

![CleanShot 2023-05-27 at 22.03.18@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/3/33036b24f2cb4dff73e8db8c5b4e2da81b9f4ab2.png)

 ![CleanShot 2023-05-27 at 22.05.06@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/7/f70f3cf6e3cce19595bf4be002c00a1d4fa11f6d.png)

 ![CleanShot 2023-05-27 at 22.02.30@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/d/9d16624608fd226997f8cdb3f123b71a6a12d1d1.png)

---

<div class="post-metadata">

**Author:** ![HouseHippo](https://avatars.discourse-cdn.com/v4/letter/h/6f9a4e/32.png) [@HouseHippo](https://community.glideapps.com/u/HouseHippo)\
**Post date:** [May 27, 2023, 2:15pm UTC](https://community.glideapps.com/t/please-fix-currency-filter-sorting-on-pages/62192/4 "2023-05-27T14:15:53Z")

</div>

Ahhh, ok this solves. Thank you.

---

<div class="post-metadata">

**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:** [May 28, 2023, 2:15pm UTC](https://community.glideapps.com/t/please-fix-currency-filter-sorting-on-pages/62192/5 "2023-05-28T14:15:54Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.