RYG formula with Open date
Hi Everyone - I'm looking to used RYG for project health, Comparing Requested Completion date with Actual Finish Date. The formula works - except when there is no date entered into "Actual Finish Date".
=IF([Actual Finish Date]@row <= [Requested Completion Date]@row, "Green", IF([Actual Finish Date]@row > [Requested Completion Date]@row, "Red", 0))
Help Article Resources
Check out the Formula Handbook template!