Forumla Help, Nested IFs
Hi, Looking to see if someone can help me with this formula. I would like it to follow the following logic:
- If Task is checked as complete= "Green"
- If Task is past complete by date and not checked as complete= "Red"
- If Task is 3 days until complete by date and not checked as complete ="Yellow"
Here is the what I have but it's not working.
=IF([Task Complete]@row, "Green", IF([Complete By]@row > TODAY(-3), "Yellow", IF([Complete By]@row >= TODAY(), "Red")))
Thank you!!
Comments
-
Try this slight modification...
There was no criterion for green. I am assuming its a checkbox based on your statement.
I would put Red next and use the Less than or equal to today. And then I would put yellow last and state Less than today + 3 days. You'll never see the equal two or less than today cause those will always fire Red. Everything else I am leaving blank.
=IF([Task Complete]@row = 1, "Green", IF([Complete By]@row <= TODAY(), "Red", IF([Complete By]@row <Today(3), "Yellow", "")))
Please let me know if this worked for you.
-
Hey Mike,
Unfortunately no, the Green worked when checked but it's doing yellow when its 3 days past the complete by date and all dates leading up to the complete by date is red.
-
Hmm. Yes, Paul's suggestion should resolve that. I think I got my greater than, and less than's mixed up. The primary issue then was that the Green didn't have the criterion. Hope that gets it working for you!
-
Excellent! Glad you found a working solution.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!