RYG Balls help

Elizabeth Jones

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!

Paul Newcome

Try something like this...

=IF([Start Date]@row > TODAY(), "Grey", IF(INT([Est. Finish]@row - [Planned Finish]@row) < 10, "Yellow", IF([Est. Finish]@row > [Planned Finish]@row, "Red", IF([Est. Finish]@row < [Planned Finish]@row, "Green"))))

Elizabeth Jones

oops and one more. If the start date is greater than today "Grey"

Paul Newcome

Try something like this...

=IF([Start Date]@row > TODAY(), "Grey", IF(INT([Est. Finish]@row - [Planned Finish]@row) < 10, "Yellow", IF([Est. Finish]@row > [Planned Finish]@row, "Red", IF([Est. Finish]@row < [Planned Finish]@row, "Green"))))