Formula Help with Dropdown Text

Jlaustse
Jlaustse ✭✭✭

I need a formula to turn a symbol column red only if "New York" or "Georgia" are selected in a dropdown of another column. Can anyone help?

Best Answer

  • Mike Wilday
    Mike Wilday Community Champion
    Answer βœ“

    =IF(OR([Name of Dropdown Column]@row = "Georgia", [Name of Dropdown Column]@row = "New York"), "Red")

    That should do the trick. Let me know if you encounter any issues.

    Supplement the name of your dropdown column. Leave the brackets if your dropdown column has a space or ends in a number.

Answers