Supporters of End User
Web

Create a Custom Sort Order in a SharePoint List

Item is currently unrated. Press SHIFT+ENTER to rate this item.1 star selected. Press SHIFT+ENTER to submit. Press TAB to increase rating. Press SHIFT+ESCAPE to leave rating submit mode.2 stars selected. Press SHIFT+ENTER to submit. Press TAB to increase rating. Press SHIFT+TAB to decrease rating. Press SHIFT+ESCAPE to leave rating submit mode.3 stars selected. Press SHIFT+ENTER to submit. Press TAB to increase rating. Press SHIFT+TAB to decrease rating. Press SHIFT+ESCAPE to leave rating submit mode.4 stars selected. Press SHIFT+ENTER to submit. Press TAB to increase rating. Press SHIFT+TAB to decrease rating. Press SHIFT+ESCAPE to leave rating submit mode.5 stars selected. Press SHIFT+ENTER to submit. Press SHIFT+TAB to decrease rating. Press SHIFT+ESCAPE to leave rating submit mode.
Categories: 

It's a common question: "How can I create a custom sort order in a list?" My typical response has been to create a hidden column called "Sort Order", manually set a numerical sort order for each item and then hide the column from view.

Today on Stump the Panel, Woody came up with an ingenious solution using the Links list as a foundation. Take a look at this one and a half minute screencast. I laughed out loud it was so simple.

Create a Custom Sort Order in a SharePoint List
           
Resources for this article:

Comments

SharePoint Daily

Create a Custom Sort Order in a SharePoint List

SharePoint Daily for March 31, 2009... Top News Stories Build and Debug Web Parts with SharePoint Extensions (Redmond Developer News) One of...

Posted 31-Mar-2009 by SharePoint Daily
Brian Salsman

Create a Custom Sort Order in a SharePoint List

Great article. I am running MOSS 2007, however, when I create a links list, I do not see the change order menu item outlined in the video ... thoughts?

Posted 03-Apr-2009 by Brian Salsman
Eddie

Create a Custom Sort Order in a SharePoint List

The screencast is broken. I'm very interested in seeing this solution in action.

Thanks!
Eddie

Posted 20-May-2009 by Eddie
EndUserSharePoint

Create a Custom Sort Order in a SharePoint List

Brian - Just checked and everything is fine with the screencast. You might want to talk with IT to make sure streaming video from ScreenCast.com is not blocked. - Mark

Posted 20-May-2009 by EndUserSharePoint
Eddie

Create a Custom Sort Order in a SharePoint List

That's what the issue was...able to get to it via our test DSL line...thanks!


Eddie

Posted 20-May-2009 by Eddie
Tom

Create a Custom Sort Order in a SharePoint List

I would like to sort order a group of folders within a document library. It seems to order on most recent update but I'm looking to have it sort on the folder name. The Link list solution doesn't appear to work for me since these are folders (with documents) and not links. Your hidden column might work - is there a video on that?

Posted 30-Jul-2010 by Tom
Gord Reid

Create a Custom Sort Order in a SharePoint List

Hello,
This is close to what I need, however, I am looking at creating a calendar roster and sorting the individuals posted to the roster in a specific order. The idea is that when a call comes in for assistance, the necesary person in order of the group 1 through 7 answers when it is their turn. All I need is the calendar to show these people on the list for the day and the position they are in. Please help!!! This one is driving me nuts!

Posted 29-Sep-2010 by Gord Reid
Sonja

Missing Screencast - Create a Custom Sort Order in a SharePoint List

What happened to the screen cast on the "Create a Custom Sort Order in a SharePoint LIst???

Posted 10-Oct-2011 by Sonja
Natasha Felshman

Missing Screencast Fixed

Hi Sonja,
 
I've added the link for the screencast.  I apologize for any inconvenience.
 
Thanks,
Natasha

Posted 10-Oct-2011 by Natasha Felshman
Sonja

Thank you!

Posted 10-Oct-2011 by Sonja
sangeet ahuja

http://sangeetahuja.com/re-order-list-items-feature/

Just came up with my own solution. http://sangeetahuja.com/re-order-list-items-feature/

Posted 27-Apr-2012 by sangeet ahuja
Christophe Chopin

Yes the solution works but :

Hello, Yes the solution works but : - You won't be able to add document anymore to an element - "+ Add new item" button becomes "+ add new link" button - Title is not editable anymore - Re-order feature does not filter element acordind to the view you want to reorder. All elements are automatically in the re-order feature. That's why I'm still looking for a solution. Chris.

Posted 14-Jan-2013 by Christophe Chopin
Roland

The solution works, but does not help me to achieve what I hoped to get out of it

Thanks for the idea.
Easy to re-order items in the Link list ("A").
However, when you want to refer to the re-ordered items from another list ("B") via lookup, the re-ordered items show up in the lookup column (in list "B") in alphabetical order, NOT in the re-ordered order (as in list "A").

Posted 17-Sep-2013 by Roland

Notify me of comments to this article

E-mail:
   

Add Comment

Title:

 
Comment:
Email:

   


Name:

 
Url: