Formula in cell in Text column not recognizing value in cell in Dropdown List Column in IF logic
Hi, I have a Dropdown list column with 5 choices. I want to use the value of the cell in that column in an IF function in another text column to add a value. The formula only works if I over type the value in the Dropdown list cell. It is not recognizing the value if it is selected from the Dropdown list. First row I re-typed "N - GLP" over what was chosen from the dropdown, second row I chose it from dropdown. Any pointers?
=IF(HAS([GTP Letter]@row:[GTP Letter]@row, "N - GLP"), "GOOD", "BAD")
Thank you for your help.
Answers
-
Double check the dropdown options don't have an extra space tucked in.
Smartsheet does not display extra spaces, but it does store them on the back-end.
Screenshot below of how I typed this post for comparison to how it actually posted:
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 140 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!