Filter problem using CONTAINS in DATA UPLOADER to select rows with specific character in a field
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?