data shuttle filter lacks an option to filter rows dynamically on date fields

I need to apply a dynamic filter criterion to a date field, specifically filtering for rows where the transaction date is current day, within a data shuttle workflow. Unfortunately, I can only find static date choices, which is inconsistent from what's possible in Smartsheet reports (where I can use the "is today" filter). Any ideas on how to work around this limitation?

Find more posts tagged with

Data Shuttle

Accepted answers

anuraggogna

@Naren, while you will need an extra column its easy to accomplish.

Create a new column called say "Today"
In the column, create a column formula, for TRUE / FALSE, to check if the date in JVd Date = Today().
This way you will get TRUE for columns where JVd Date is today.

Now as this represents a static column, you can use filter on this column in your data shuttle. Also, you can hide this column in sheets so as not to add clutter. Hope it helps. Let me know if you need any further clarity on above steps.

All comments

Tim C

Can you post screenshots for the worklow, target and source columns in each smartsheet or excel/ csv? And is the source sheet Smartsheet or target sheet?

Naren

Thank you for your response.

Source: Smartsheet

Target: Onedrive/Teams folder

Data shuttle filtering screenshot:

Report screenshot:

anuraggogna

@Naren, while you will need an extra column its easy to accomplish.

Create a new column called say "Today"
In the column, create a column formula, for TRUE / FALSE, to check if the date in JVd Date = Today().
This way you will get TRUE for columns where JVd Date is today.

Naren

@anuraggogna I appreciate the workaround; it should work, but I was hoping someone might identify something I had missed, possibly already built into the data shuttle's filtering capabilities (though that may have been wishful thinking). I'm optimistic that the Smartsheet product team will acknowledge this need and include the "is today" option in the data shuttle workflow filtering in the near future, eliminating the need for creating additional helper columns that consume unnecessary space.

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.