Formula for Priority Cell

AB
AB ✭✭
edited 12/09/19 in Formulas and Functions

Hello All:

 

I am having a difficult time creating a formula that will give me Priority. Below are my rules for Priority Status. Thanks

 

Urgency High

If Impact High and Urgency High, then Priority is 1

If Impact Med and Urgency High, then Priority 2

If Impact Low and Urgency High, then Priority 3

 

Urgency Med

If Impact High and Urgency is Med, then Priority 2

If Impact Med and Urgency is Med, then Priority 3

If Impact Low and Urgency is Med, then Priority 4

 

Urgency Low

If Impact High and Urgency is Low, then Priority 3

If Impact Med and Urgency is Low, then Priority 4

If Impact Low and Urgency is Low, then Priority 5

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!