Forum Discussion
Trouble sorting numbered folders
Hello all, hoping someone can solve my (very) minor problem.
I have a list of folders I need to sort numerically. The numbers are 2.1.0 - 2.2.13 and cannot be changed at all (so no 2.1.01 as it's referred to as 2.1.1 in numerous other documents).
I can't use a number column as only numerals are allowed. I can't use a text column as it puts eg 2.1.3 after 2.1.13.
What is a fairly straightforward solution to this? We use Sharepoint Online pretty much how it comes. Most of the users are not especially tech savvy; the solution can't involve coding. I know there's a symbol section when you edit a number column, but you can only put them at as the first or last digit, not in the middle.
Any help much appreciated
1 Reply
HSAlerts create a new number column in your library called SortOrder. Enter the order position for each folder and sort on that column from smaller to larger. It will need manually updating if new folders are added but that is the only way to do it due to the way SharePoint sorts from left to right.
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)
