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

All good, worked it out went with Index and collect and used a help sheet
=INDEX(COLLECT({Priority Scale Master Range 1}, {Priority Scale Master Range 2}, [Urgency Rating]@row, {Priority Scale Master Range 3}, [Importance Rating]@row), 1)
Thought I would add the outcome, just incase it helps anyone else :)

Hey @Cathy Fraser
I'm glad you figured it out! Thanks for posting your solution 🙂
Need more help? 👀  Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋  Global Discussions
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.6K Get Help
 403 Global Discussions
 215 Industry Talk
 454 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 56 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 296 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!