RYGB Formula

KathyLRichards

Can you help me create a formula for the following?

If Assessment Sent is blank = Red

If Assessment Sent is a date and Complete is blank = Yellow

If Complete is a date = Green

Screen Shot 2022-07-13 at 6.34.23 PM.png

Mike TV

@KathyLRichards

=IF(AND(ISBLANK([Assessment Sent]@row), ISBLANK(Complete@row)), "Red", IF(AND(ISDATE([Assessment Sent]@row), ISBLANK(Complete@row)), "Yellow", IF(ISDATE(Complete@row), "Green")))