Case-sensitivity in filters on text fields

gamgc

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

Mike Wilday

Have you tried using the match function with a 0 in the optional operator to find an exact match? 

https://help.smartsheet.com/function/match

Look under usage notes for the use of 0. That might help you out. 

gamgc

Hi Mike,

Unfortunately you can’t use the match function in a filter.

Regards,

GAM