In-app sort feature not working for the price column

Hi,

I have a price column for my products and trying to use the in-app sort feature to allow a user to sort the list of products by price.

Unfortunatly the feature seems to be sorting the price in a weird way. For example instead of 1.99, 2.99, 3.99, 12.99, 20.00 and 34.99, I’m getting 1.99, 12.99, 2.99, 20.00, 3.99, 34.99. So it’s only looking at the first digit rather than theentire figure. I’ve tried changing the column from text to number and vice versa and I get the same result.

Any suggestions on what I can do to fix it?

1 Like

Check the column type in the data editor. It’s numeric or string? May be the second.

3 Likes

I had it as number currency and it didn’t work. Then I changed it to just number and it worked. Thank you!

2 Likes

You’re welcome