3

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? – SP Developer Jul 27 '17 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 '17 at 13:52
0

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 '17 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 '17 at 12:35
0

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 '17 at 10:30

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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