Multiple IF statements in the formula
Hi!
I want to create a priority matrix using urgency and important. I've used this formula below. There is no error on the formula but the cell only returns P2. I feel I'm doing something wrong with adding multiple IF statements. Please help
=IF(Urgency@row = "NOT URGENT", IF(Importance@row = "IMPORTANT", "P2", IF(Urgency@row = "URGENT", IF(Importance@row = "IMPORTANT", "P1", IF(Urgency@row = "NOT URGENT", IF(Importance@row = "IMPORTANT", "P3", IF(Urgency@row = "NOT URGENT", IF(Importance@row = "NOT IMPORTANT", "P4"))))))))
Best Answer

Thank you, it worked when I used
=IF(AND(Urgency@row = "URGENT", Importance@row = "IMPORTANT"), "P1", IF(AND(Urgency@row = "NOT URGENT", Importance@row = "IMPORTANT"), "P2", IF(AND(Urgency@row = "URGENT", Importance@row = "NOT IMPORTANT"), "P3", IF(AND(Urgency@row = "NOT URGENT", Importance@row = "NOT IMPORTANT"), "P4"))))
Answers

Try a series of IF/AND combos instead.
=IF(AND(Urgency@row = "NOT URGENT", Importance@row = "IMPORTANT"), "P2", IF(AND(...........
However... This can get rather long and unwieldy very quickly depending on the number of combinations you can have. I generally suggest setting up a matrix on a separate sheet and using a formula with cross sheet references to pull the appropriate output.

Thank you, it worked when I used
=IF(AND(Urgency@row = "URGENT", Importance@row = "IMPORTANT"), "P1", IF(AND(Urgency@row = "NOT URGENT", Importance@row = "IMPORTANT"), "P2", IF(AND(Urgency@row = "URGENT", Importance@row = "NOT IMPORTANT"), "P3", IF(AND(Urgency@row = "NOT URGENT", Importance@row = "NOT IMPORTANT"), "P4"))))

Happy to help. 👍️
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.3K Get Help
 321 Global Discussions
 197 Industry Talk
 418 Announcements
 4.2K Ideas & Feature Requests
 127 Brandfolder
 154 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 278 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!