Forum Discussion
Sharepoint library - how to sort document by multiple columns
I have a SharePoint library with multiple columns/metadata - year, month,. I would like to create a view where my documents are sorted by year, and then by month (placing the most relevant files in ...
How are your month columns? Are they just text fields? If so you're going to have to use a calculated column and either try seeing if you can use a function to convert text to date value and sort on that so it will sort in date order, or you'll have to use a bunch of IF statements to assign a value to the month names then sort by that column.
Both the year and month columns are text fields but the data in there is values. So, 01 for January etc.
I can sort newest to oldest by sorting Z to A. But I can only sort by one column at a time.
- If you edit the view and go into the old classic setting page, you there is a sort section there, where you can sort by more than one column, you set one then the next etc.