IF and Isblank on date field

AghoT

Hi,

Please I need your help. I have two date fields - Expected completion date and actual date completed. I'm trying to create a formula to say if actual date completed is greater than expected completion date, "Red", if actual date completed is blank, "Gray", else "Green"

My formula is: IF([Actual Date Completed]@row > [Expected completion]@row, "Red", IF([Actual Date Completed]@row < [Expected completion]@row, "Green", "Gray"))

Mark.poole

@AghoT

=IF(ISBLANK([Actual Date Completed]@row), "Gray", IF([Actual Date Completed]@row > [Expected completion]@row, "Red", "Green"))

Mark.poole

@AghoT

=IF(ISBLANK([Actual Date Completed]@row), "Gray", IF([Actual Date Completed]@row > [Expected completion]@row, "Red", "Green"))

AghoT

Thank you @Mark.poole