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?
Best Answer
-
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.
Answers
-
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.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives