I have a sheet, that uses numerical ranks to keep track of projects. These ranks are simple number assignments (i.e: 1, 1.1, 1.2, 2, etc.), that we use to determine the priority of the project. If a project changes priority, or we have a new project that comes in at a high priority we have to manually update the numerical rank.
Is there a known way to automate this, so any changes made to the sheet will automatically update the numerical rank to reflect the change in priority as projects are shifted around?
Help Article Resources
Check out the Formula Handbook template!