Forum Discussion
Can I configure a SharePoint list to sort by legal or outline numbering?
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.
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)
2 Replies
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!
