Filter problem using CONTAINS in DATA UPLOADER to select rows with specific character in a field

David Hundley

I am using DATA UPLOADER to load rows from an Excel Spreadsheet into Smartsheet based on selection criteria. I created a filter but it doesn't seem to be filtering as I expect. The source Excel file has a column called Price with values in it (e.g. $50.00). It also has a few values that are invalid that I want to screen out. Below is a snip of the problem...

I want to filter out rows like with those values highlighted.

In DATA UPLOADER, I have created a simple filter as follow:

The syntax for CONTAINS that I found says to enclose characters in double quotes. Any idea why this does not work and how I need to filter to do this?

RossL

@David Hundley

The filter logic will report all rows in witch the filter expression evaluates to true. So your filter is asking to bring in rows that contain E if you want to exclude the rows with E then you would need does not contain.

RossL

@David Hundley

The filter logic will report all rows in witch the filter expression evaluates to true. So your filter is asking to bring in rows that contain E if you want to exclude the rows with E then you would need does not contain.