Impact with Urgency equals Priority

Hi, I am looking into utilizing a ITIL related priority matrix approach to populate a Priority. The

Priority levels column's cell would have values P1, P2, P3, P4, P5. The formula needed in the Priority column would output an appropriate priority level based on specified combination of values from two other columns: Impact and Urgency.

Impact column values of "High" "Medium" or "Low" with

Urgency column values of "Critical", "Soon", "Normal" or "Minimal"

I believe I need to use IF and FIND, and perhaps AND functions. I'm getting stuck with establishing a viable formula. Does anyone have or use a similar formula or something upon which I can build an appropriate structure?

IF [Impact]1 = "High" AND [Urgency] = "Critical" THEN output "P1" , and so on.

Find more posts tagged with

Formulas

IT & Operations

Product Development

Project Management

Comments

L_123

=IF(Urgency1 = "High", IF(Impact1 = "Critical", "P1", IF(Impact1 = "Soon", "P1", IF(Impact1 = "Normal", "P1", IF(Impact1 = "Minimal", "P1")))), IF(Urgency1 = "Medium", IF(Impact1 = "Critical", "P2", IF(Impact1 = "Soon", "P2", IF(Impact1 = "Normal", "P2", IF(Impact1 = "Minimal", "P2")))), IF(Urgency1 = "Low", IF(Impact1 = "Critical", "P3", IF(Impact1 = "Soon", "P3", IF(Impact1 = "Normal", "P3", IF(Impact1 = "Minimal", "P3")))))))

gonna have to change which priority it posts because you weren't exactly clear about what you wanted, but all you need is a long nested if statement

Scott A.

Thanks! I'll check into that.

Sign in to join the conversation!

Quick Links

Trending discussions

Compare Previous Week
Hello, I am trying to be able to say whether hours went up or down as compared to the previous week but am having trouble referencing the previous week. I have tried to add a helper column but am still getting an error. Any help would be greatly appreciated!
SUMIFS Formula with Date Column
Hello All, I am using this formula " =SUMIFS({RCX- Kit Forecast - 2025 Range 1}, {RCX- Kit Forecast - 2025 Range 2}, ">=" + TODAY(), {RCX- Kit Forecast - 2025 Range 2}, "<=" + (TODAY() + 5)) " Range 1 is the number column Range 2 is a date column But the value is coming as zero
Workflow to trigger comms when number exceeded but not in between.
Hi, trying to work out how I can get a workflow to trigger only when certain milestone numbers are met. For example, I'd like an email comm to be sent once the sum of a column reaches 50, 100, 150, 200 etc. The number will be entered via a form, very basic, so for example 4 entries could be sent via 4 form inputs (15, 11,…