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.

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

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:

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.