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?
Can you show an example from your sheet as to how your said sheet is determining the priority? Based on what you have stated here, since the ranking of the project is based on the priority, we'll need to create a relationship between the two columns using an IF statement. So that, the ranking is calculated on the logic of priority as -
=IF((Priority)>="High", 1) and so on and so forth... where Priority is High, Medium, Low etc.
Thank you for the reply Ipshita. I'm attaching a quick screengrab of what I'm working with. My company uses "rank" to determine a tasks priority. Rank 1 tasks are the most important and so forth. As new tasks come in, we rank them; accordingly, and depending on the needs of the businesses we may see a rank 10 task, move up to rank 4 priorities (or vice versa).
What I'm trying to solve for (hopefully with automation) is that whenever we have a new task (we'll manually type the initial rank) or a change in priority. We can update the rank and the rankings will update via automation to the new information. Does that make sense?
1.1 would have the highest rank and highest priority
1.2 would have the highest rank but next to highest priority
If this is accurate you could do a column for rank input and a column for priority input that you would input the initial rank and priority and then update as needed. The formula below could go in your Rank column.
Ipshita ✭✭✭✭✭✭
Tbrooks ✭
