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
- 66.9K Get Help
- 441 Global Discussions
- 153 Industry Talk
- 501 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 79 Community Job Board
- 511 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!