Add Ons and Integrations

Add Ons and Integrations

Ask questions about Control Center, Dynamic View, DataMesh, Pivot App, Calendar App, or WorkApps. Discuss connecting Smartsheet to your other systems with integrations such as Bridge, Data Shuttle, the Jira connector, and the Salesforce connector.

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

Best Answer

  • Community Champion
    Answer ✓

    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!

    If this answer resolves your question, please help the Community by marking it as an accepted answer. I'd also be grateful for your response - "Insightful"or "Awesome" reactions are much appreciated. Thanks!

Answers

  • Community Champion
    Answer ✓

    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!

    If this answer resolves your question, please help the Community by marking it as an accepted answer. I'd also be grateful for your response - "Insightful"or "Awesome" reactions are much appreciated. Thanks!

  • ✭✭

    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.

Trending Posts