Impact with Urgency equals Priority

Options
Scott A.
Scott A. ✭
edited 12/09/19 in Formulas and Functions

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. 

 

Tags:
· Share on FacebookShare on Twitter

Comments

  • L_123
    L_123 ✭✭✭✭✭✭
    Options

    =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

    · Share on FacebookShare on Twitter
  • Scott A.
    Scott A. ✭
    Options

    Thanks!  I'll check into that.

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!