Formula based on two column values

Hi, I am looking at doing a formula that looks at two columns and provides a # value based on what on the values that are in the two columns

This is a simple formula that I am looking at, but it will only go two levels down and then stops.

=IF([Urgency Rating]@row = 1, IF([Importance Rating]@row = 1, "1", IF([Urgency Rating]@row = 1, IF([Importance Rating]@row = 2, "2", IF([Urgency Rating]@row = 2, IF([Importance Rating]@row = 1, "3", IF([Urgency Rating]@row = 3, IF([Importance Rating]@row = 1, "4", IF([Urgency Rating]@row = 2, IF([Importance Rating]@row = 2, "5", IF([Urgency Rating]@row = 1, IF([Importance Rating]@row = 3, "6", IF([Urgency Rating]@row = 2, IF([Importance Rating]@row = 3, "7", IF([Urgency Rating]@row = 3, IF([Importance Rating]@row = 2, "8", IF([Urgency Rating]@row = 3, IF([Importance Rating]@row = 3, "9"))))))))))))))))))


Not sure what I am doing wrong?

I really appreciate any help you can provide.

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!