Creating a priority level based on important/urgent values

%3CLINGO-SUB%20id%3D%22lingo-sub-2106517%22%20slang%3D%22en-US%22%3ECreating%20a%20priority%20level%20based%20on%20important%2Furgent%20values%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2106517%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20first%20time%20posting%20for%20help.%3C%2FP%3E%3CP%3EI'm%20rolling%20out%20a%20master%20document%20within%20our%20business%20around%20projects%20and%20tasks.%20Each%20author%20has%20graded%20the%20level%20of%20IMPORTANCE%20and%20URGENCY%20between%201%20and%205%2C%201%20being%20the%20most%20and%205%20being%20the%20least%20in%20each%20case.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20to%20categorise%20these%20in%20priority%20order%20with%20each%20task%2Fproject%20having%20differing%20priority%20based%20on%20the%20value%20given%20to%20to%20them%20above%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20anyone%20help%20with%20a%20formula%20that%20I%20could%20apply%20to%20overecome%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2106517%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hi, first time posting for help.

I'm rolling out a master document within our business around projects and tasks. Each author has graded the level of IMPORTANCE and URGENCY between 1 and 5, 1 being the most and 5 being the least in each case. 

 

I need to categorise these in priority order with each task/project having differing priority based on the value given to to them above

 

Can anyone help with a formula that I could apply to overecome this?

 

Thanks

 

1 Reply

@Graham1963 

 

Your request is not entirely clear. For one thing, you ask if there's "a formula that I could apply to overecome this?" and I assume--please confirm--that you really mean achieve rather than overcome.

 

That said, are you aware of the sort capability? There is a SORT function which can be used to yield a new listing, on a separate sheet, of a list of projects or tasks, based on the column in which those rankings have been entered. There's also a Data...Sort menu selection that can accomplish the same thing on the basic table of raw data. The advantage to the former is that it leaves your raw data intact.

 

But a further question: I'm assuming the tasks are a sub-level within the project: so the question arises whether you are seeking to do some kind of weighted categorization based on the weights assigned to each task within a  project? Or something else?

 

If you could attach a sample either of your actual spreadsheet (provided you can share it without revealing proprietary or confidential data) OR a representative but fictitious example, that would help us help you. Without seeing the actual layout of data, we're basically limited to general suggestions as above.