Case-sensitivity in filters on text fields

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

Find more posts tagged with

Services

IT & Operations

Enhancement Request

Comments

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

Sign in to join the conversation!

Quick Links

Trending discussions

Sheet -Ganhtt Chart
Is it possible to display both the planned and actual duration for a single task on a Smartsheet Gantt chart? I would like the Gantt bar to show the planned duration (e.g., in blue) based on a Planned End Date column, and then show the actual duration (e.g., in green) based on an Actual End Date column. Can the Gantt view…
Color-Coded Tags in Board View
I noticed in the Board View tags are grey by default but in the how to videos, in the Board View some of the tags are colorful. I'd like to leverage that same functionality as I'm building a research repository with many different types of research in it and a visual cue would be lovely. Can anyone assist? I attached a…
Can we run the request for update to include all the rows that applied to one condition?
We want to know if it is possible to send request for update in one email, but with multiple rows at the same time. For example, staff A has 4 open referrals, I want to send one request for update automatically to them where they will receive only one email without having to overload them daily with all the open referrals…