Adding to RAG Formula

Kaleb

@Genevieve P. I have Figured it Out. Thank GOD!

Final Formula for Project Health:

=IF([Schedule Status]@row = "Not Started", "Gray", IF(AND([Schedule Status]@row = "Behind", [% Complete (Plan)]@row - [% Complete (Actual)]@row > 0.1), "Red", IF(AND([Schedule Status]@row = "Behind", [% Complete (Plan)]@row - [% Complete (Actual)]@row < 0.9), "Yellow", IF(OR([Schedule Status]@row = "On Track", [% Complete (Actual)]@row = [% Complete (Plan)]@row), "Green"))))

Thanks for All your Help @Genevieve P. and @Paul Newcome

Genevieve P.

Hi @Kaleb

I'm so glad to see you found a formula that works for you! Thank you for posting your solution. 🙂