How to rank Sharepoint Online list items?

Question

I have a SharePoint list, and need to numerically rank items in order of importance. Right now I simply have a number column set to unique values, but it occurs to me that with this method if for example the item with a rank 14 importance suddenly got bumped up to rank 3, I'd have to manually re-number nearly the entire list. What I'd like to be able to do in the above example is to automatically have the previous rank 3 (and all items below that) automatically bump down... basically the same functionality that ordering columns in the List Edit view has. Is this even possible? Thanks!

Answer 1

Hi @chris pressley ,

Currently, I think that when we change the order using integers, we cannot automatically reorder other items below the previous item.

As a workaround, we can use decimals to change the order of item, items less important than the previous value will automatically move down.

Result for your reference:

---------------------------------------------------------------------------------------------------------------------------------------------------------------

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.