I have a huge custom list with several columns. They are grouped by e.g. Status, but the order of the groups cannot be influenced as it is strictly alphabetical. Is there a (nice) way how to customize the order of the groups within the list without using prefixes for the Status, e.g. 1_Initiated, 2_Started, 3_Completed?

  • Are u want to group by alphabetically without using number prefixs like Completed, Initiated, Started? am i right? Jul 27, 2017 at 12:24
  • I want to order it by myself. Without prefixes. But the only thing available OOTB is "order alphabetical" ascending/descending. I want to order the groups by myself, freehand so to say.
    – user68489
    Jul 27, 2017 at 13:52

2 Answers 2


You could create a hidden column where you have a calculated column with an IF statement giving each value e.g.

IF([Status]="Initiated",1,(IF([Status]="Started",2,IF([Status]="Completed",3))) and so on. Use this then to order the group.

  • Thanks alot, I think this solved my issue in a nice way! Your help was highly appreciated.
    – user68489
    Jul 28, 2017 at 10:29
  • One last question: Sharepoint does not let me "Hide" the Calculated column, it seems it is not allowed? The selection for the content type is not greyed out, I simply cannot click "Hide" as type.
    – user68489
    Jul 28, 2017 at 12:35

Look at how quick launch links are ordered in SharePoint or how columns are ordered in a view. This is the closest SharePoint comes to having a user customizable order. And STILL this functionality is not available as a column type for a list or library.

So, sorry, NO this is not possible with OOTB SharePoint.

But, in a post by Stump the Panel from 2009 they prove you CAN do this if you start with a link list! enter image description here

  • Thanks for you input, I think the solution suggested by Ciara is even more elegant, but I will try the link-version as well!
    – user68489
    Jul 28, 2017 at 10:30

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.