I wonder if someone has any recommendations to my issue. Essentially I've built a list that contains a field that essentially allocated a business ranking number which used another List to allocate the number using math calculation plus 1. The issue I have is that a user would like to revise the business priority # to perhaps 1 for a specific item that has a ranking number of 15 for example. What I need is a workflow that will refresh the existing allocation business priority # to accommodate for the newly allocated priority of 1. This would only occur when the item has been modified.
Any advice would be greatly appreciated!