Red, Yellow, Green Formula

Cody_Gomez32

I am trying to get the Red, Yellow, Green dot formula to work with the information below.

Smartsheet.PNG

Red = If [submitted date] is in the past and [Assigned Engineer] is blank

Yellow = If [Assigned Engineer] is not blank

Green = If [Completed] is checked

JamesB

@Cody_Gomez32

Try This...

=IF(Completed@row = 1, "Green", IF(AND([Submitted Date]@row < TODAY(), ISBLANK([Assigned Engineer]@row)), "Red", IF(NOT(ISBLANK([Assigned Engineer]@row)), "Yellow")))

Note: If the Date is today or in the future and no Engineer is assigned the cell will be blank.

JamesB

@Cody_Gomez32

Try This...

=IF(Completed@row = 1, "Green", IF(AND([Submitted Date]@row < TODAY(), ISBLANK([Assigned Engineer]@row)), "Red", IF(NOT(ISBLANK([Assigned Engineer]@row)), "Yellow")))

Note: If the Date is today or in the future and no Engineer is assigned the cell will be blank.

Cody_Gomez32

That worked. Thank you for your help.