Nest IF statement with an AND embedded for RYG
I am struggling to create a statement that would say:
IF the finish date is less than three days away AND the percentage is less than 60% then RED, If the finish date is less than three days away and is less than 75% complete then YELLOW, and the rest is green...
Help Article Resources
Check out the Formula Handbook template!