Formula Help with Dropdown Text

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?

Mike Wilday

=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.

Mike Wilday

=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.

Jlaustse

This worked! Thank you Mike!

Mike Wilday

Awesome! Glad I could help you out.