whats wrong with my formula??

mramsamooj

I am following along with training and this is the formula i am using but it keeps returning error

=IF(Status@row = "Complete", "Green"), IF(DueDate@row < TODAY(), "Red", "Yellow")

Leah Rankin

You have a misplaced parenthesis. Should be:

=IF(Status@row = "Complete", "Green", IF(DueDate@row < TODAY(), "Red", "Yellow"))

Hope that helps!

Leah Rankin

You have a misplaced parenthesis. Should be:

=IF(Status@row = "Complete", "Green", IF(DueDate@row < TODAY(), "Red", "Yellow"))

Hope that helps!

mramsamooj

OMG!! that worked!!! thank you so much!!!!!