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 DeveloperJul 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.– user68489Jul 27, 2017 at 13:52
Add a comment
|
2 Answers
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. 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. 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!
-
Thanks for you input, I think the solution suggested by Ciara is even more elegant, but I will try the link-version as well! Jul 28, 2017 at 10:30