Filtering for a Particular Value When Multiple Exist

569x

I am using a text type column to populate multiple values that I would like to be able to filter on.  However, the values have letters and/or numbers that because of schema show up in the Filter output that are not desired.  MS Project uses commas (and some other values that you define) as separators.  Does Smartsheet use separators to allow similar values without pulling them in a Filter when a particular value is expected?

Example:

Various Rows of data contains the values in column 2 of: A, AA, B, C

Column 1     Column 2

Row 1                A

Row 2                AA

Row 3               B

Row 4               C

Creating a filter to identify in column  2 those rows that "contain" A returns Row 1 and Row 2.  I am interested in only returning Row 1 in my results.

I hope that is clear and would appreciate any assistance.

Shaine Greenwood

You might want to set your filter to "is equal to," screenshot included.

I tested this, and when using "...is equal to A" it didn't return AA or other combinations with A in them.