Please Fix Currency Filter/Sorting on pages!

[HouseHippo]

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.

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.

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.

[Eric_Penn]

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

[Darren_Murphy]

@HouseHippo

(I can’t use “number” column since the currency symbol is removed).

Works for me

[HouseHippo]

Ahhh, ok this solves. Thank you.