There seems to be 2 column limit. How can I sort by more columns? I have 6 columns I wnat to sort by

Hi,

You might have to use CAML to perform your query if you want to sort by more than 2 columns.

You could modify your view using SharePoint designer.

I've already done it in the past using a Content Query WebPart and the QueryOverride parameter.

<OrderBy>
  <FieldRef Name="Newcomers"/>
  <FieldRef Name="Years" Ascending="FALSE"/>
  <FieldRef Name="Location"/>
</OrderBy>

Ex : https://msdn.microsoft.com/en-us/library/office/ms467378.aspx

Regards

Samuel Levesque | http://sharepointerie.com | Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

How about like this....
1) add one hidden column
2) concatenate 6 columns' value into the hidden column
3) sort the hidden column