Microsoft list + Multiple columns sort

Question

Hi,

I would like to know if it possible to sort by multple column in Microsoft List ? Like... Sort by date, then part number, then another detail etc...

We user Airtable for the moment, but would like to move to Microsoft List.

Thank you !

Answer 1

Dear Antonin Audard,

Good day!!

I understand your concern and I would like to like to convey in the Modern experience you can sort only one column at a time in the SharePoint Online List or Microsoft Lists but you create a new standard view in the List, you can apply sorts on two columns:

Open the List> Settings> List Settings> Scroll down to View> Create view> Standard View> Fill the name for the view and enable the options as per your requirement> Save the View.

Reference: Use sorting to modify a SharePoint view

Moreover, you can also use the Group By feature in the SharePoint Online list for grouping the items based on the metadata of the column. Reference: Use grouping to modify a list or library view - Microsoft Support

Appreciate your patience and understanding. Have a good day!!

Best Regards,

Sophia

Answer 2

Thank you Sophia,

I will pass this information to our users and see if they can manage with a two column sort instead of three columns.

Or maybe if they can manage with a combination of two columns sort + Group By.

Have a nice day ! :)

Answer 3

Is it possible to have more tan 2 columns in the sort?

I couldn't find the trick :-(

Answer 4

Did anyone find a way to sort by 3 columns? Example: Date, Time, Data?

Answer 5

No, unfortunately we have not found a way yet...

So in our case, we will have to rely on AirTable solution since Microsoft Product is not as good for the moment.

:\