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?
=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.
Hi all. I am new to Smartsheet and I am building my first form. Is there a way to set up a form to show additional fields that will only appear after it is submitted? These new fields will be filled out by someone other than the person who submitted the form. They will be viewing this in the card view. Thanks for any help!
I hope I can explain this well enough it makes sense! We are trying to verify a temperature reading with a probe that sits in a tank of water with another thermal temperature reading to ensure our probe in the bath is reading correctly. What we need is for our 1 temperature reading to be within 5 degrees of the other. Is…
Looking to connect a dynamic view of HR dataset to a Power BI dashboard pulling information from multiple other sources. Appreciate any guidance, thanks
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.