How to sort alphabetically with German umlauts (Ä, Ö, Ü)?
I want to sort a list with Names, but all names with umlauts (Ä, Ö, Ü) then appear an the bottom. Can I change the settings so that it sorts correctly (Ö will appear as Oe, etc...)?
Would be great when someone has a solution for my problem. Thanks in advance!
Julian
Best Answer
-
The only thing I can think of would be to use a helper column with a nested SUBSTITUTE function to swap out the umlauts with their equivalent for sorting.
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(Name@row, "Ö", "Oe"), "Ä", "value"), "Ü", "value")
You can hide this helper column to keep the sheet looking clean but still sort on it even when it is hidden.
Answers
-
The only thing I can think of would be to use a helper column with a nested SUBSTITUTE function to swap out the umlauts with their equivalent for sorting.
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(Name@row, "Ö", "Oe"), "Ä", "value"), "Ü", "value")
You can hide this helper column to keep the sheet looking clean but still sort on it even when it is hidden.
-
thanks, Paul! Great idea😀
-
Happy to help. 👍️
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 454 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives