Dynamic numbering of feature list

tim_kuykendall@dell.com

I have a feature list that has a number associated with each of them (by row). I'd like to be able to reorder the list as I get input on their priority and have the number associated with it dynamically update. For example, if #5 moves ahead of #3, I'd like #5 to be #3 and the others below to reorder too.

Paul Newcome

You can insert a text/number column and use this column formula...

=MATCH([Idea Name]@row, [Idea Name]:[Idea Name], 0)

Paul Newcome

Can you provide a screenshot of what you are working with?

tim_kuykendall@dell.com

Here is an example. I'd like to be able to move a feature/idea up or down based on customer feedback and have the order adjust accordingly. For example if I moved feature C ahead of Feature A, then Feature C would have 1 ranking and Feature A would have 2.

Paul Newcome

You can insert a text/number column and use this column formula...

=MATCH([Idea Name]@row, [Idea Name]:[Idea Name], 0)

tim_kuykendall@dell.com

This works just like I needed. Thank you so much. I had a ProDesk Session and they weren't able to find a solution for this one. Much appreciated.

Paul Newcome

They may have just been missing the fact that you are essentially replicating the row number. We aren't trying to re-order the numbers, and your number 1 starts on row 1. Replicating row numbers isn't what you are trying to do, but because of how your data is laid out it just happens to work.