Data Shuttle Offload Filter with Checkboxes

I am trying to use filters to only offload data where the Facilitator Helper Column box is checked, but the Finalize Archive checkbox is unchecked. I originally had the filters set up where the Facilitator Helper Column equals true AND the Finalize Archive Column equals false. I had 1 row that met that criteria, but all data was filtered. I then changed it to Facilitator Helper Column does not equal false AND the Finalize Archive Column does not equal true. This offloaded 13 rows, however again, only 1 row meets both criteria. It seems to be offloading all rows where the Finalize Archive Column is not checked, and does not pay attention to the Facilitator Helper Column. Any insights into what I'm doing wrong?

Find more posts tagged with

Accepted answers

All comments

ChristianFinke

Hi @HR_Training

It looks like Smartsheet may be interpreting the “not equal to” criteria too broadly. Try setting Facilitator Helper Column to “equals true” and Finalize Archive Checkbox to “equals false” instead. Make sure the filter logic at the top is set to 1 AND 2 to apply both conditions together. If it still doesn’t work as expected, there could be a glitch, and contacting Smartsheet Support might help.

If you and your team would like any further assistance or would like anything built out in Smartsheet please feel free to reach out.

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.