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.

569x

Yes, but what if you had a value in that column that contained A and After?  Would it return both values?

Shaine Greenwood

When I tested this, it filtered out everything that wasn't equal to the character A.

You may need to apply the filter and test it out on your sheet to make sure it completely works for you.