I have spreadsheet that lists actions that are necessary to be taken and the
priority that each task has in relation to one another. Priorities are
numeric with the number one being the most important and some number less
than one less important. As priorities chage (eg from 3 to 2 or vice versa),
I would like for all of the other listed priorities to update sequentially to
reflect the change made to one of the tasks priorities. Said another way,
when a task with a priority of nine becomes a task with a priority of five,
the original five then becomes six and the original six becomes seven, etc.
Is there a way to do this without having to manually adjust the priorities
to reflect the change of one tasks priorities?
|
Similar Threads
