SOLVED

Can I configure a SharePoint list to sort by legal or outline numbering?

Copper Contributor

Example would be items with values as follows in a number column:

 

1.0 Main Topic

1.1 Subtopic

1.11 Sub-subtopic

 

And so on. My brain hurts, I have not been able to find a viable solution to this as the Number column type does not allow for more than one period or decimal point. 

2 Replies
best response confirmed by jenbaier81 (Copper Contributor)
Solution

@jenbaier81 the only way to do this is with a single line of text column. But given that SharePoint sorts from left to right you will need to make sure your numbering is 1.0, 1.01, 1.02, 1.11 etc.

 

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

Rob, you are an absolute lifesaver. Such a simple solution!
1 best response

Accepted Solutions
best response confirmed by jenbaier81 (Copper Contributor)
Solution

@jenbaier81 the only way to do this is with a single line of text column. But given that SharePoint sorts from left to right you will need to make sure your numbering is 1.0, 1.01, 1.02, 1.11 etc.

 

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

View solution in original post