Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Filtering for a Particular Value When Multiple Exist

edited 12/09/19 in Archived 2017 Posts

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?


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.


This discussion has been closed.