Status is <> Complete and the Need by date is behind todays date then should change symbol to RED

Greg Zinn

IF the status is not COMPLETE and the need by date is behind todays date would want to have the color be Red. If it is current or in the future of todays date would be Green.

Been striking out... here was my latest try

=IF(Status@row <> "Complete", "Red", "Green"), IF(AND([Need by Date]@row<=TODAY()), "Red", "Green")))

Laura B.

Try this:

=IF(AND([Need by Date]@row <= TODAY(), (Status@row <> "Complete")), "Red", "Green")

Laura B.

Try this:

=IF(AND([Need by Date]@row <= TODAY(), (Status@row <> "Complete")), "Red", "Green")

Greg Zinn

Thank you this worked amazing!!!!