Formula Help with Dropdown Text
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
-
=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
-
=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.
-
This worked! Thank you Mike!
-
Awesome! Glad I could help you out.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives