Shift numbers down sequentially in a column

jhorvath

I have a column that organizes my tasks (rows) by priority. So, my highest priority is 1 and my lowest is 10, etc. When I add a new task to the spreadsheet and I decide that it is now the highest priority, I want to put 1 in the "Priority" column and then everything else in that column goes down one number sequentially. So, what was previously 1 in priority is now 2 and so on. Is there a way to do this?

jhorvath

Actually I need to do this the other way around too. I want to delete 1 when my first priority task is done and then 2 becomes 1 and so on.

Paul Newcome

I believe we may already have a solution here:

https://community.smartsheet.com/discussion/85919/formula-to-shift-numbers-in-a-column