Sort by "Name" A > Z is sorting data into two A>Z lists, not one

Hello. It appears the “sort by” option isn’t working in a couple of my bases. When sorting by the name field (A), it is creating two consecutive lists A>Z. It isn’t sorting them alphabetically as one column. They are not grouped, filtered, or sorted by anything else. Nothing weird with their names, no punctuation or anything like that. Checked two other bases, one is working (only has 43 records), and the other isn’t sorting properly either. Any suggestions? Thank you!

I would double-click into the name fields for the first set of A fo Z, and see if there is a leading space before the names.

Annoyingly, Airtable hides leading spaces when you click out of the field, even if the leading spaces are there.

2 Likes

That’s it! Thank you so much. I’ll check my zaps and see if there’s something causing the leading spaces.

1 Like

You’re welcome! Glad I could help! :slight_smile:

Also, if you have a chance, please be sure to email support@airtable.com to request that they stop trimming leading spaces. It’s super annoying, and has caused countless problems for people!

Will do! Thank you again.

2 Likes

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.