Issue with ENUM Base Type Text

[MauriceWhelan]

Hi. I have a column [Bin Number] which is an ENUM with Base Type Text. There are some values in the table that are alphanumeric. When I look at the drop down option in the UX it seems to be showing NaaN for any non numeric values. e.g. the NaaN value in the attached screenshot should be 8A.

I am using a Select expression in the ValidIf expression editor.

Could someone advise how to solve this issue?

Thank you.

[Steve · Accepted solution]

Make sure the spreadsheet column is formatted as plain text; or, if using a database, make sure the column’s type is VARCHAR.

[MauriceWhelan]

Thank you @Steve. Working perfectly now.