What is wrong with my IF...AND stmt?
=IF(AND([# of Days Open]@row >= 22, Status@row = "Pending Review"), "Red",
IF(AND([# of Days Open]@row <= 14, Status@row = "Pending Review"), "Green",
IF(AND(Status@row = "Pending Review", AND([# of Days Open]@row >= 15, [# of Days Open]@row <= 21), "Yellow"))))
In my calc above, it was working fine until I added the 3rd IF stmt solving for Yellow. I'm basically wanting to code my bubble yellow if project status = Pending Review AND the # of Days Open is between 15 and 21. What am I missing? Is it the last AND function that's causing issues?
SB
Best Answer
-
This was corrected by adding in the parenthesis in the right sections. Basically they were in the wrong spot. See revised code below.
=IF(AND([# of Days Open]@row >= 22, [Status]@row = "Pending Review"), "Red",
IF(AND([# of Days Open]@row <= 14, [Status]@row = "Pending Review"), "Green",
IF(AND([Status]@row = "Pending Review", AND([# of Days Open]@row >= 15, [# of Days Open]@row <=
21)), "Yellow", " ")))
Answers
-
This was corrected by adding in the parenthesis in the right sections. Basically they were in the wrong spot. See revised code below.
=IF(AND([# of Days Open]@row >= 22, [Status]@row = "Pending Review"), "Red",
IF(AND([# of Days Open]@row <= 14, [Status]@row = "Pending Review"), "Green",
IF(AND([Status]@row = "Pending Review", AND([# of Days Open]@row >= 15, [# of Days Open]@row <=
21)), "Yellow", " ")))
-
Thank you for posting your solution! I'm glad you were able to get it working. 🙂
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives