1

I have my SharePoint list grouped by Status but they are not being ordered in numerical order.

I want them to be ordered as

1. Status Name
2. Status Name

etc

10. Status name
11. Status Name

They are currently displayed as

List screenshot

1

if its possible for you to rename the status texts, you can prefix them with zeroes and so, to make alphanumeric sorting possible. Of course its not a nice solution in a production environment where people are allready using them, but if its under development it could be a solution.

|improve this answer|||||
1

Well the Status column is not of Number type, but of type Text. Hence SharePoint sorts it like text. For example, it is not easy to correctly sort "10a" in your snippet above

|improve this answer|||||
  • Not easy or not possible? – Enilorac Feb 11 '14 at 12:30
  • OOTB, not possible. with super awesome custom XSLT: probably possible ;) – Robert Lindgren Feb 11 '14 at 12:32
  • 1
    Actually, adding zeroes at the beginning should sort your groups right. You should experiment about adding the named sub-points (a), but you can still make it work if you stick to a good naming convention. For example - always put interval after the number, and then put the letter. – P.G Feb 11 '14 at 13:31
  • @PetyaG, That is a quite ugly solution but surely doable ;) And it relies on the fact that OP can rename the status texts – Robert Lindgren Feb 11 '14 at 13:36
  • Of course there is an option to do it pretty - like you said through xslt. But it again involves changing the status names. For example you can create your own numbered prefix that will not be rendered on the end user view. Groups will still be sorted by their 'true' value (with the prefix) - not the one rendered on the page. – P.G Feb 11 '14 at 13:45
0

Group by status with Ascending. My status column is a Choice column with status choices in the same order.

I don't have any problem

|improve this answer|||||

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.