Stump the Panel » End Users and Information Workers

Ordering items in a list

(6 posts)

  1. jlschu1
    Member

    Hello - I am wanting to sort items on a list in a numeric order and I can up with the idea of creating a custom column called Sort Order that is a numeric column type. I then modify the view to sort by the sort order column in ascending order. This is works for my list for now, but there is any way to automate so when I change number it shifts everything below to a new number. For example, Adding a new item and assigning to 1, the old 1 item will move to 2. Hopefully this makes sense. Right now I have manually update each item.

    I am on MOSS 2007.

    thanks!

    Posted 3 days ago #

  2. woodywindy
    Member

    There's good news, and bad news.

    The Bad News:
    There isn't really a way to add an automatic "re-ordering" column to an existing list.

    The Good News:
    The Links list-type already includes an order column. You might be able to achieve your goals by adding fields to a links list.

    Posted 3 days ago #

  3. eric
    Moderator

    It would likely have to be some crazy workflow to handle that automatically since updating the sort column wouldn't necessarily change the item it is replacing.

    I get what you are trying to do, but don't know of a way to do it easily.

    Posted 3 days ago #

  4. EndUserSharePoint
    Key Master

    Woody - Very nice solution. Use the links list and add other columns to fillout what is needed. I just tried and was able to implement in about 45 seconds. This is a common request, creating sort order. Good trick. -- Mark

    Posted 3 days ago #

  5. EndUserSharePoint
    Key Master

    Published a quick screencast to show how easily it can be done:
    http://www.endusersharepoint.com/?p=1477

    Mark

    Posted 3 days ago #

  6. jlschu1
    Member

    Thanks for the tip on the links list. I will consider building on a links list when sorting is needed.

    Posted 1 day ago #

RSS feed for this topic

Reply

You must log in to post.