Filter and Sort showing in wrong order when using numbers

Hi there!

I noticed that when you add a filter or a sort, and you sort it by something with numbers in the name, the order is incorrect. Example: It shows 1, 10, 11, 12, 2, 3, 4, 5, 6, 7, 8, 9 instead of 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12. It’s not a big deal, but I just wanted to let you know. :slight_smile:

Thanks!

Because your sort is based on a text column, I think it’s the way it normally behaves.

G’day Leo,

This happens when numbers are stored as a String.
It’s not really a bug of the platform.
Just the way data is.

To overcome this, you can:

  1. Have the numbers in two digits - Lektion 01 etc.
  2. Have another column to store a sort order, and sort it by this column.

Hope that helps.

Thanks so much, I’ll try that!