Need assistance with unparseable project health formula using IF/AND statements

Current Formula:

=IF([% Complete]@row = 1, "Gray"), IF(AND(TODAY(5) < [Due Date]@row, [% Complete]@row < 1), "Red"), IF(TODAY(15) < [Due Date]@row, IF([% Complete]@row < 1, "Yellow", "Green"))))

Goal of formula:

  1. Red = % Complete is less than 100% and < 5 days of Due Date
  2. Yellow = % Complete is less than 100% and < 15 days of Due Date
  3. Green = % complete is less than 100% and > 15 days of Due Date
  4. Gray = % complete is 100%

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!