Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Sort not sorting as expected

Solved
Jump to Solution
542 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

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?

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