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

569x
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?

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.

Comments

  • 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.

    Screen Shot 2017-05-17 at 1.13.08 PM.png

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

  • 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.

This discussion has been closed.