Auto-numbering automation

Hello

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?

Answers

  • Ipshita
    Ipshita ✭✭✭✭✭✭

    Hello @Tbrooks

    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.

    Hope this helps,

    Cheers!

    Ipshita

    Ipshita Mukherjee

  • Tbrooks
    Tbrooks ✭✭

    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?


  • Hollie Green
    Hollie Green ✭✭✭✭✭

    If I am understanding correctly

    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.

    =[Rank input]@row + "." + [Priority input]@row

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!