A lookup field that includes a comma sorts first

[Michael_Spina]

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?

[andywingrave]

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?