Help

Sort not sorting as expected

Solved
Jump to Solution
1056 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Greg_Witkamp
6 - Interface Innovator
6 - Interface Innovator

I’m expecting this group of records to be sorted in the opposite direction. It doesn’t seem like it’s sorting by the entire string since “.5” is before “.25” and “.75” is after “.25”

Is there a way to correct this?

image

1 Solution

Accepted Solutions
kuovonne
18 - Pluto
18 - Pluto

Sometime Airtable does funny things when sorting strings with numbers. My guess is that Airtable is sorting “5”, “25”, and “75”. If you change the “0.5” to be “0.50”, does it sort properly?

See Solution in Thread

2 Replies 2
kuovonne
18 - Pluto
18 - Pluto

Sometime Airtable does funny things when sorting strings with numbers. My guess is that Airtable is sorting “5”, “25”, and “75”. If you change the “0.5” to be “0.50”, does it sort properly?

Greg_Witkamp
6 - Interface Innovator
6 - Interface Innovator

You know what Kuovonne, you’re a smart one. That did the trick.