Case-sensitivity in filters on text fields

Options
gamgc
gamgc ✭✭✭✭
edited 12/09/19 in Smartsheet Basics

Hi,

Does anyone know if there’s a way to do this currently, as it seems to be stumping me. E.g. I have 2 rows with “ERF_” in one column in one row and “erf_” in the same column in the other. When I filter on that column, I get the same result whether I use “erf_” or “ERF_”; i.e. both rows are returned. This seems to imply that filters on text fields are case-insensitive, which is the wrong choice between the 2, as you can always build case-insensitivity if you have case-sensitivity but not vice-versa.

Regards,

GAM

Comments