What is wrong with this formula?

Hi,

Could one of you please tell me what is wrong with this formula:

=IF([% Complete]@row = 100%, "Blue", IF([End Date]@row <= TODAY, "Red", IF([End Date]@row < TODAY(5), "Yellow", "Green")))

I keep getting an #UNPARSEABLE error.

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!