Help With Formulas

jennifer.cooper15596

I am attempting to automate the RYG column shown in the screen shot below.  I need the formula to look at the finish date and status columns if the status is not "Done".

I need some feedback on the formula that I am using below.

=IF([Finish]1 < TODAY(), "Red", IF([Finish]1 = TODAY(), "Yellow", IF([Finish]1 > TODAY(), "Green", IF(AND[Status]1 = “Done”, “Green))))

Shaine Greenwood

Hi Jennifer,

Your images didn't make it through. I'm not sure what feedback you're looking for, but I can see a few issues with the formula you copied into your discussion:

1. It combines straight quotes and curly quotes. Please make sure to only use straight quotes.
2. You have an IF(AND()) statement at the end with no second condition. I think you're wanting to combine the last two statements, the last part of your formula should look more like this: ...IF(AND(Finish1 > TODAY(), Status1 = "Done"), "Green")))
3. You're missing quotes on the text string of "Green" at the end of your formula.