In a meeting that determines what we work on first, we put our task into a speadsheet. during the meeting the spreadsheets gets updated, some tasked eliminated, some task are added and priorities of others are changed. What we currently doing is we give each task a priority number which might get changed after reviewing some of the other task. ie: if we have 50 tasked numbered and then a new task comes in and it's determined that it should be the top priority and given a 1, then we currently have to renumber the current 1 to 2, the current 2 to 3 and so on manually, then sort the data manually again.

Is there a way that if we change the number of a task, it renumbers the other task automatically? We can still do the sort manually. say for instance the number 25 task of the 50 task was changed to be the number 15 task, it would automatically change the old 15 to 16 and so on up to 50. task 26 - 50 shouldn't need to be changed. That would allow us to update a number of task then do a sort to see where we stand.