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

[Lisa_Dalton]

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!

[ScottWorld]

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.

[Lisa_Dalton1]

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

[ScottWorld]

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

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!

[Lisa_Dalton1]

Will do! Thank you again.