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.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!