Sorting Folders by number in sharepoint

Question

I want to sort my folder numerically by the name.

right now they are labelled like

I would like to have them show in order, right now the sort is putting "incident 9" after "incident 89"

I realize that's because the fields are text.

What would I need to do to sort the files numerically.

Any assistance would be greatly appreciated.

Answer 1

Hi @Cameron Francis ,

There is such a paragraph in the article mentioned by esjimenezp, which mentioned that the reason for the confusion in the sorting of this case, as you said, is because the Name column is a text field column.

At the moment I can only offer you a workaround:
Create a Number column showing the same numbers as in the folder, sort this column and hide it.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

The easiest workaround I could find was using a 01-99 format or 001-999 format for numbers, depending on how many values you will have.

The numbers column type didn't work for me, as I couldn't find how to actually populate the column unfortunately.

Answer 3

Hi,

Try to use this function in your List View use-sorting-to-modify-a-sharepoint-view-1e85d6e7-bdb3-4176-b1cb-62c5fbd3ef98

Answer 4

I know this thread is over a year old but this is possible - the number column can be added. The trick is to edit in grid view - put in numbers in 01-10 or 001-100 format in the number column then sort appropriately + hide if you need to - I just keep it to the far right and its generally not visible unless I scroll over to see it