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))

Thank you

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    Basically we want to say

    =IF(appropriate date > [Requested Completion Date]@row, "Red", "Green")

    Then we use an IF statement to output the "appropriate date". In this case we say

    "IF the [Actual Finish Date]@row is not blank, then use the [Actual Finish Date]@row, otherwise use TODAY()."


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!