Hi all,

I am trying to create a custom field that contains the order of an item in the list. For example, I created a custom object called "Request." I would like to have a field that indicates the ranked order of the requests. The ranking is from 1 to however many requests there are.

I would then like to be able to change the order of the requests. So if I change ranking of a request from 10 to 5, that request should take the #5 spot, and the original 5-9 items will be shifted down.

Is there anyway to do this?

Thanks