Oct 01 2020 09:00 AM - edited Oct 01 2020 09:01 AM
My sharepoint library sorts by the first digits instead of numeric order:
Example
99 - file
100 - file
1202 - file
1215 - file
123 - file
How do I make it sort:
Example:
99 - file
100 - file
101 - file
123 - file
1202 - file
1215 - file
Can anybody tell me how to fix this?
Oct 01 2020 09:20 AM
@Marinpetersen you can only sort SharePoint library views in numeric order on a number field. Text fields will always sort alphabetically
Oct 01 2020 09:26 AM
Oct 05 2020 12:50 PM
@Marinpetersen You could create a second column that just contains the number and sort on that. You should be able to keep it hidden and still sort on it in the view settings. You MIGHT even be able to create that second column as a Calculated column based on your column so you don't have to worry about data entry.
I'm not 100% on the calculated column working out, but it's probably worth a shot.