Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 29 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Dynamic Priority Field

Solved
Jump to Solution
2279 2
cancel
Showing results for 
Search instead for 
Did you mean: 
GaryC
4 - Data Explorer
4 - Data Explorer

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?

1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

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

See Solution in Thread

2 Replies 2
TheTimeSavingCo
18 - Pluto
18 - Pluto

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

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