Data Shuttle Filter using multiple "does not contain" filters

I am trying to filter out a series of market lines from my Smartsheet that contains dozens of markets using a does not contain logic pathway. Right now i am using the following, but it allows in all the markets.

I do not want to use the contains logic since i sometimes get unique identifiers that I want to get in.

Is this an AND OR mix up?

All the market names are copied from sourcing files, so no typos, no capitalization, no spaces

Find more posts tagged with

Accepted answers

Kerry St. Thomas

Yup - I agree with what you're thinking: this is the difference between AND and OR. Consider something with MemberMarket "Houston." That row's MemberMarket does not contain "Northeast Florida" so even though you think it's filtered out by your #1, it's filtered right back IN with #2. If you change your filter logic, you'll probably see considerably different results from the Shuttle.

Good luck!

All comments

Kerry St. Thomas

Good luck!

DanBonn

I got it to work as (1) AND 2 AND 3 AND 4 AND 5 AND 6 AND 7. Probably would work without the parentheses. thanks.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.