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.
Comments

=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

Thanks! I'll check into that.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.3K Get Help
 364 Global Discussions
 200 Industry Talk
 428 Announcements
 4.4K Ideas & Feature Requests
 136 Brandfolder
 127 Just for fun
 128 Community Job Board
 445 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!