Formula for RYG status based on Drop down column marked: Complete, In Progress & Not Started

Hi there! I am looking for help creating an IF formula to produce the RYG based on another column that has a dropdown (Complete, In Progress & Not Started).

This is what I had:

=IF([email protected] = "Completed", "Green", IF(AND([email protected] = "In Progress", "Yellow", IF(AND([email protected] = "Not Started"), "Red"))))

Best Answer


  • Summer
    Summer ✭✭✭
    Answer ✓

    Hi @M.Q.

    Try it without the AND statement.

    =IF([email protected] = "Not Started", "Red", IF([email protected] = "Completed", "Green", IF([email protected] = "In Progress", "Yellow", "")))

  • That worked, Thanks @Summer!

    I am also looking to do a average of the those children row on the parent row to automatically update the RYG. So if most of the health status are red in the children, then the parent will also be red.