Forum Discussion

PerA's avatar
PerA
Copper Contributor
Sep 19, 2025
Solved

Sorting a SharePoint List alphabetically it Swedish

Hi!   I'm working on a ShrePoint site for my organisation and have run into an issue with a SharePoint list. The entire site is in Swedish and I've run inte issues when Grouping/Sorting.    In th...
Lists
SharePoint Online
  • PerA's avatar
    PerA
    Sep 23, 2025

    Thanks for your input. I went a slightly different direction, but your answer gave me the inspiration needed.

     

    At first I had a similar idea, but I didn't like the idea of replacing the letters, since the whole point of the calculated column is to be able to GROUP by the first letter of the title.

     

    I got inspired by your suggestion however and managed to solve it with the following formula:

    =IF(
    OR(
        LEFT(Title)="Å";
        LEFT(Title)="Ä";
        LEFT(Title)="Ö"
        );
    LEFT(Title);
    CONCATENATE("​";LEFT(Title))
    )

    ​On line 8 there is a ZeroWidth Space between the quotation marks, which results in the formula adding an invisible space in front of the letter for all letters except Å, Ä, and Ö. When grouping/sorting, spaces and punctuation comes before letters.

SteveHendy's avatar
SteveHendy
Brass Contributor
Sep 22, 2025

AI tells me... You could create a calculated column with a formula like:


=IF(LEFT([Title],1)="Å", "Z1",
 IF(LEFT([Title],1)="Ä", "Z2",
 IF(LEFT([Title],1)="Ö", "Z3",
 LEFT([Title],1))))

  • This formula assigns "Z1" to Å, "Z2" to Ä, "Z3" to Ö, and otherwise uses the first letter.
  • You can then sort by this calculated column to get your desired order.



PerA's avatar
PerA
Copper Contributor
Sep 23, 2025

Thanks for your input. I went a slightly different direction, but your answer gave me the inspiration needed.

 

At first I had a similar idea, but I didn't like the idea of replacing the letters, since the whole point of the calculated column is to be able to GROUP by the first letter of the title.

 

I got inspired by your suggestion however and managed to solve it with the following formula:

=IF(
    OR(
        LEFT(Title)="Å";
        LEFT(Title)="Ä";
        LEFT(Title)="Ö"
        );
    LEFT(Title);
    CONCATENATE("​";LEFT(Title))
    )

​On line 8 there is a ZeroWidth Space between the quotation marks, which results in the formula adding an invisible space in front of the letter for all letters except Å, Ä, and Ö. When grouping/sorting, spaces and punctuation comes before letters.

Resources