Sorting Names with Accent Marks

We serve an international client base, and when I go to sort names in a smartsheet I built for a client directory, instead of placing names with accent marks in alphabetical order, the sort places all names with accent marks at the bottom of the list. For example, José would be sorted with the "J" names, but placed at the bottom of the "J" names.

Find more posts tagged with

Sheets

Comments

Shaine Greenwood

Hello,

I tested this using a Text/Number column and a Contact list column, and when using the name "José" along with other names without accent marks, José sorted with the other "J" names.

Keep in mind that Smartsheet sorts alpha-numerically. In a Contact list column, Smartsheet sorts by first name only. Since José starts with Jo- it's likely going to sort toward the bottom of the "Js."

If your José is sorting below names like "June" then please reach out to our Support team to troubleshoot the behavior further.

tylermh

Thanks, Shaine. I'm including a screenshot of what's happening on my end. I wonder how/why your test worked. The Last Name column I'm sorting on is a Text/Number column FYI. So this would require a Support team ticket then, right?

Sign in to join the conversation!

Quick Links

Trending discussions

Automation not working
I have a Smartsheet automation setup to reminder the planning to complete their sections. It is setup to remind weekly until completed box is checked. They received 2 reminders and then the reminders stopped. Any idea what could be wrong? I can't tell that anything has changed in the sheet. Thanks Freda
How to disable popups that obscure my formula?
I'm editing formulas in a Sheet Summary. However, I'm prevented from seeing the formula by an annoying "helpful" popup that obscures my view. I can't figure out how to get rid of the popup. Does anyone know?
Workflow Error: "Recipients: Edit workflow to fix recipients list"
I am trying to create a workflow and for some reason it gives me an error with the email I entered as the recipient for my Alert. It is an email that I know works, it is shared to the sheet, and the access to the sheet is unrestricted. I am perplexed at what the issue is. Anyone else get this and know what the issue is?