Am stuck with an IF(AND formula

=IF(AND([% Complete]@row < 1, [End Date]@row > TODAY(), "Red", IF(AND([% Complete]@row < 1, [End Date]@row <= TODAY(), "Amber", "Green"))))

which should mean (in my dreams :))

if under 100% and the date is past, then red

if under 100% and the date is today and future, then amber

otherwise green

Where am I wrong please

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!