If Date is between Today and 4 Days from Today = YELLOW
I've been looking at the different threads for an example that I can use for this formula but could not find anything that helps.
What I'm looking for is if the END DATE is less than today, RED. If its greater than today and less than 4 days in the future, YELLOW, otherwise GREEN. I'm getting YELLOW for any date <= TODAY. END DATES for 10/24/22 should be GREEN.
=IF([End Date]4 < TODAY(), "Red", IF([End Date]4 >= TODAY(-4)), "Yellow", "Green")
Answers
-
This may help,
=IF([End Date]@row < TODAY(), "Red", IF([End Date]@row - TODAY() < 4, "Yellow", "Green") )
-
@Sameer K Thank you so much, That worked.
edit:
If I wanted to add an extra step, to say add the color code only if Status3 is not COMPLETE. If STATUS is COMPLETE, then no color code. This didn't work for me.
IF([End Date]3 < TODAY(), "Red", NOT(Status@row = "Complete"), IF([End Date]3 - TODAY() < 4, NOT(Status@row = "Complete")"Yellow", IF([End Date]3 - TODAY() > 4, NOT(Status@row = "Complete")"Green"), IF(Status@row = "Complete")""))
-
In that case it will be,
=IF(Status@row <> "Complete", IF([End Date]@row < TODAY(), "Red", IF([End Date]@row - TODAY() <4, "Yellow", "Green") ) )
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!