Need a formula to change one RYG column if another RYG column changes.

Myles Armstrong

I have a "Drawings Status" column that changes to Yellow when a date is reached and another column is blank. I need the RYG to change in the "EQ Status" column if the "Drawings Status" column turns Yellow. I know its an IF formula but not sure how to structure it.

Nick Korna

Hi @Myles Armstrong,

It would be something like this (with the EQ Status RYG in this example turning green when the drawing status goes yellow):

=IF([Drawings Status]@row = "Yellow", "Green")

If you want a different colour to green, just update the word in the final set of speech marks to the preferred one ("yellow" or "red").

Hope this helps, but if I've misunderstood anything or you've any problems/questions then just let us know!