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

A lookup field that includes a comma sorts first

Topic Labels: Base design
360 1
cancel
Showing results for 
Search instead for 
Did you mean: 

It took me a while to troubleshoot, but it seems to come down to commas. When I sort by a lookup field, if a row has a comma anywhere in it, it sorts first, despite what it starts with.

In the original table they sort like this:
01 item
02 item
03 item
04 item, item

But if that field is the lookup and is sorted, it goes like:
04 item, item
01 item
02 item
03 item

Is this a bug or am I missing something?

1 Reply 1

Hey there! Welcome to the community!

I think this will really depend on how you’ve sorted your data.

Would you be able to share a screenshot or an embed of some dummy data so we can help you further?