Help with Health Formula

When I put this formula: =IF([% Complete]@row = "100%", "Green", IF(AND([% Complete]@row <> "100%", [Due Date]@row >= TODAY()), "Yellow", IF(AND([% Complete]@row <> "100%", [Due Date]@row < TODAY()), "Red", "")))
The status shows Red when the % complete is 100% and the Due date is past. How can I correct that?
Thanks
Best Answers
-
@cvilla
The issue comes into it finding everything false except the due date being less then today(). What exactly are you wanting it to show. Know that I can fix it for you. Keep in mind the way nested IF functions work is they will continue until it finds the first true statement.If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
-
Try this:
=IF([% Complete]@row = 1, "Green", IF(AND([% Complete]@row < 1, [Due Date]@row <= TODAY()), "Yellow", IF(AND([% Complete]@row < 1, [Due Date]@row > TODAY()), "Red", "")))
Hope that helps!
All the best,
-Ray
Answers
-
@cvilla
The issue comes into it finding everything false except the due date being less then today(). What exactly are you wanting it to show. Know that I can fix it for you. Keep in mind the way nested IF functions work is they will continue until it finds the first true statement.If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
-
Try this:
=IF([% Complete]@row = 1, "Green", IF(AND([% Complete]@row < 1, [Due Date]@row <= TODAY()), "Yellow", IF(AND([% Complete]@row < 1, [Due Date]@row > TODAY()), "Red", "")))
Hope that helps!
All the best,
-Ray -
Thanks, the formula above helped.😀
-
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!