Forum Discussion

Sam_Green's avatar
Sam_Green
Copper Contributor
Apr 27, 2023
Solved

SharePoint: Control the grouping order

Hi. When using group by in a SharePoint list I want to set the grouping order, sorting by alphabetical is not appropriate for my list.

 

Example: I want to group by Day of the week so I have another list that sets Monday as 1, Tuesday 2 ....

The list that I want to sort looks up on my reference list and returns the sort order.

When grouping by the Day column the order is alphabetical (see image) is it possible to set the sort order of column 'order' to override the grouping order?

 

A work around would be to prefix the days of the week with the sort order but I really don't want to do this due to other implications for my site.

(days of week just used as an example, actual data is different).

 

Any ideas would be appreciated.

Thank you

  • Hello Sam_Green 

     

    same here, per default it is not possible to override the group sorting with the column sorting 😞 .

     

    Best, Dave

2 Replies

  • Mark215's avatar
    Mark215
    Copper Contributor

    I have the same problem. Would like to group items in a non-alphabetical or numerical order. 

  • Hello Sam_Green 

     

    same here, per default it is not possible to override the group sorting with the column sorting 😞 .

     

    Best, Dave

Resources