RYG Balls help

Hi All,

I would like the RYG balls to represent how closely we are tracking to our timeline.

The bit I need help with is having the Yellow ball appear if the est. finish is within 10 days of the Planned Finish.


=IF([Est. Finish]@row > [Planned Finish]@row, "Red", IF([Est. Finish]@row < [Planned Finish]@row, "Green"))


So if it's within 10 days of the finish date I'd like it to appear yellow. If it's more than that, Red.


Thanks!

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!