Red, Yellow, Green Formula


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

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

Best Answer

  • JamesB
    JamesB ✭✭✭✭✭✭
    Answer ✓


    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.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!