Adding to a Complex Formula

Anthony Barthelemy
Anthony Barthelemy ✭✭✭✭✭✭
edited 12/21/19 in Formulas and Functions

Good morning All:


I am trying to add RYG to my Formula. Here are my conditions:

If 15+ Days Behind Schedule = Red

If Between 5-15 Days Behind Schedule = Yellow

If 0 or Ahead of Schedule = Green


Current Formula without RYG:

=IF(ISBLANK([Actual Date]@row), "", IF(AND(ISBLANK([Planned Date]@row), ISDATE([Actual Date]@row)), "Start Date Missing", IF([Planned Date]@row - [Actual Date]@row < 0, ABS([Planned Date]@row - [Actual Date]@row) + " Day(s) Behind Schedule", IF([Planned Date]@row - [Actual Date]@row > 0, ABS([Planned Date]@row - [Actual Date]@row) + " Day(s) Early", IF([Planned Date]@row - [Actual Date]@row = 0, "0 Variance, On Schedule")))))


Thanks

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!