Sharepoint List - ranking move up / move down

Question

_{Monday, February 7, 2011 2:14 PM}

I've build a simple Project list for my team. I'm looking for a way to move a single row up or down...kind of like a way to rank projects.

I have a priority field (high, medium, low) and this helps. i've got a view group by priority that helps.

but within a priority grouping, if there are multiple projects with the same priority, i want to be able to move or rank one higher than another.

Does anyone have a good ranking formula? I would think some kind of rank field would do it. But I also wonder if there's some built in re-order functionality that i'm not aware of.

Bob

All replies (4)

_{Monday, February 7, 2011 5:26 PM ✅Answered}

There is no Move Up/Move Down feature that I know of. You can build a custom field type that achieves it, but a RANK column is the quickest OOTB solution. Generally, list items in SP are "independant" of each other.Independant SharePoint Consultant. Feel free to contact me. Blog: http://www.sharepoint.bg/radi Twitter: @RadiAtanassov

_{Monday, February 7, 2011 3:38 PM}

I think you need to create views based on the available columns and if you don't have a column that fits naturally with the ranking you want, you'll need to create it.

What is the business driver?  Maybe there is a better way?

--Paul Galvin, Computer Generated Solutions (CGS)
  Microsoft MVP - SharePoint
  Blogging @ http://www.mstechblogs.com/paul
  Twitter @ http://www.twitter.com/pagalvin

_{Monday, February 7, 2011 4:38 PM}

Well, I was thinking that there should be a "move up/move down" type of positioning that i could enable in the list.

Kind of the way that you re-order the columns when creating a view.

For example, if I had (three rows) of projects, each with a high-priority, i'd like to be able to have the end-user re-order them.

Ranking:       Project Name

1                  Develop Widget

2                  Develop Super Widget

3                  Develop Mega Widget

if the manager of the group, felt like Develop Mega Widget, out of all high-priority projects should be the top, i'd like to be able to have him re-order it using a move up / move down thing, or a re-order thing.  so the list could look like

1                  Develop MEga Widget

2                 Develop Widget

3                  Develop Super Widget

I could manually put in a RANK column that is an integer. Then I could have that person just glance at the list and re-order the numbers manually. but as the project list grows, this becomes unreasonable.

What'd I'd like to see is some kind of RANK ID field, but some way of having the user choose "move up" or something like that and behind the scenes the list is re-ordered.

If you are in MS Project for example, you can drag a task up or down to re-order task rows. I know this is Sharepoint (and not MS Project 2007 Pro), and i'd like to present the manager with some easy way of re-ordering the list of active projects.

Bob

_{Monday, September 12, 2011 6:59 PM}

I'm looking for the same thing.  Did you ever find a workable solution?