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

Myles Armstrong
edited 03/20/24 in Formulas and Functions

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.

Answers

  • Nick Korna
    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!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!