Dynamic Priority Field

[GaryC]

Sorry if this is obvious, and I've just been unable to find a solution, but... Is there any way to create a PRIORITY field that changes dynamically? Imagine there are ten projects in a base, with a Priority field numbered 1-10. I now need to add an eleventh project, but this one is more urgent and has a priority of 2 on the list. Currently, I then have to manually change the old Priority 2 to a 3, 3 to a 4 and so on. Is there a way to automate this?

[TheTimeSavingCo · Accepted solution]

I'm afraid not.  As a workaround you could try sorting by the priority field, turning off the sort, moving that new task so that it's number two in the view, and then creating an autonumber field?

Purely automated you're probably going to need a script or something I think

[GaryC]

I thought that might be the case. Thanks for that.