Filtered column not showing relevant data

trent · 06/14/23

I am trying to filter a column on an item number. I create a new filter on the 'Product' column with the 'contains' condition and enter the item number as the value. The filter returns no results. If I paste that same exact item number into the Search bar in the top right corner of the webpage and filter the location to 'Current Sheet' the row is found. What am I doing wrong with the filter for it to not find the row that clearly exists?

Paul Newcome · 06/14/23

Are you able to provide screenshots for reference?

Frank S. · 06/14/23

Greetings@trent,

Without more information, my response will be based on what I think might be the issue.

My assumptions:

The product column is not a list of item numbers but a name or description.

There is a column that contains item numbers.

Possible solution:

When using the filter on the sheet, it will only look at the column you specify, whereas the search bar will search the entire sheet.

If the item number is in a different column, use that column or a combination of columns to get the item you are looking for.

I hope this helps and that my assumptions were pretty close.

trent · 06/14/23

@Paul Newcome @Frank S.Thank you both for the reply. I have added some screenshots and additional info below.

SS of my Product column. Product numbers are in this column.

ss1.png

Creating filter to search for the top row - item# 1000460

ss2.png

That filter not returning any rows.

ss3.png

Using the Search function in the top right corner does find the correct row when I select 'Current Sheet' for the location.

ss4.png

I appreciate your help!

Thanks,

Trent

AravindGP · 06/16/23

Hi Trent,

Contains looks for the value to be part of a larger value/string. For example, if the value was Product# 1000460, you can use Contains and "1000460" to get the value in the filter. The better option would be to use "is one of" or "is equal to"

Filtered column not showing relevant data

Answers

Categories