Another nested IF question
Hi, after reading all the previous questions/answers, I'm still not able to figure out what I am doing wrong. In plain language, here is what I want the nested IF formulas to do:
 If [Priority level]@row is greater than 44, return a value of "Red"
 If it's greater than 28 and less than 45, return "Orange"
 If it's greater than 19 and less than 29, return "Yellow"
I've tried a couple different approaches; neither has worked and I keep getting the UNPARSEABLE error. I can't tell if the formulas are completely wrong or if I have just misplaced some brackets/parentheses.
IF([Priority level]@row>44,"RED", IF[Priority level]@row>28 AND [priority level]@row<45, "ORANGE", IF[Priority level]@row>19 AND [priority level]@row<29, "YELLOW","")
IF([Priority level]@row > 44, "RED", IF[Priority level]@row > 28, "ORANGE", IF[Priority level]@row > 19, "YELLOW") (I also tried this one without all the spaces and it still didn't work)
Thank you in advance for helping me troubleshoot!
Best Answer

YES! Thank you so much!! I didn't realize that I needed a "(" immediately after each IF and then all of the ")" stacked up at the end.
Answers

The second formula was good, just missing a few brackets.
=IF([Priority level]@row > 44,"Red",IF([Priority level]@row > 28,"Orange",IF([Priority level]@row > 19,"Yellow","")))

YES! Thank you so much!! I didn't realize that I needed a "(" immediately after each IF and then all of the ")" stacked up at the end.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63K Get Help
 379 Global Discussions
 212 Industry Talk
 442 Announcements
 4.6K Ideas & Feature Requests
 140 Brandfolder
 129 Just for fun
 130 Community Job Board
 449 Show & Tell
 30 Member Spotlight
 1 SmartStories
 304 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!