Data Shuttle

Eric Laitenberger
Eric Laitenberger ✭✭✭✭✭
edited 06/14/22 inAdd Ons and Integrations

Hello,

I would like add a filter to import Data (Date) which is greater than a date.

Is it possible?

数据Shuttle.docx


Best Answer

  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓

    Hi@Eric Laitenberger

    No, I don't believe you can use TODAY in the filter, it would need to be a UTC date. However, you could add a column in the source sheet with a formula to identify the criteria you need, then filter the DataShuttle workflow based off the output of this formula.

    In regards to column names, you can have different column names in your Source data and in your Smartsheet Sheet, however you'll just need to make sure that you map the correct column to each other in the Mapping section of the workflow.

    Cheers,

    Genevieve

Answers

  • Genevieve P.
    Genevieve P. Employee Admin

    Hi@Eric Laitenberger

    Yes, you can use the Filter tab in Data Shuttle to filter by dates, however the date will need to be entered in UTC format: (YYYY-MM-DD)

    Try adjusting your formatting in Data Shuttle to be: 2021-01-01

    Cheers,

    Genevieve

  • Eric Laitenberger
    Eric Laitenberger ✭✭✭✭✭

    Hi, yes perfect.

    And is it possible to put a function? EG: "TODAY-1" instead of a date?

  • Eric Laitenberger
    Eric Laitenberger ✭✭✭✭✭

    Sorry I have another question.

    If I would like move line according criteria from shhet to another:

    Must we have the same name of columns throught these sheets?

  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓

    Hi@Eric Laitenberger

    No, I don't believe you can use TODAY in the filter, it would need to be a UTC date. However, you could add a column in the source sheet with a formula to identify the criteria you need, then filter the DataShuttle workflow based off the output of this formula.

    In regards to column names, you can have different column names in your Source data and in your Smartsheet Sheet, however you'll just need to make sure that you map the correct column to each other in the Mapping section of the workflow.

    Cheers,

    Genevieve

Categories

It's a great idea and I'd encourage you to submit a feature request<\/a>. <\/p>

You can view Dashboard activity using the Activity Log<\/a> though if you're an admin on the Dashboard.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-09-26 17:01:43","updateUser":{"userID":142957,"name":"PaulPerger","url":"https:\/\/community.smartsheet.com\/profile\/PaulPerger","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-27T00:33:09+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":95895,"type":"question","name":"Duplicate a column, including properties. in a sheet.","excerpt":"Is there a way to duplicate a column including the properties (Not necessarily the data)?","categoryID":321,"dateInserted":"2022-09-26T13:48:35+00:00","dateUpdated":null,"dateLastComment":"2022-09-26T14:14:48+00:00","insertUserID":148602,"insertUser":{"userID":148602,"name":"Mike B","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Mike%20B","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-26T15:39:17+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2022-09-26T14:54:36+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":21,"score":null,"hot":3328402403,"url":"https:\/\/community.smartsheet.com\/discussion\/95895\/duplicate-a-column-including-properties-in-a-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/95895\/duplicate-a-column-including-properties-in-a-sheet","format":"Rich","lastPost":{"discussionID":95895,"commentID":344754,"name":"Re: Duplicate a column, including properties. in a sheet.","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/344754#Comment_344754","dateInserted":"2022-09-26T14:14:48+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2022-09-26T14:54:36+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-09-26T14:17:20+00:00","dateAnswered":"2022-09-26T14:14:48+00:00","acceptedAnswers":[{"commentID":344754,"body":"

You would have to manually create a new column and set the properties to match.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-09-26 14:17:20","updateUser":{"userID":148602,"name":"Mike B","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Mike%20B","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-26T15:39:17+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":95848,"type":"question","name":"Numerical value of character","excerpt":"Can we extract the numerical value of a character ? Kind of a \"Char^-1 \" Char(112)= p Char^-1(p)=112 <--- that is what I'm looking for.","categoryID":321,"dateInserted":"2022-09-23T15:06:14+00:00","dateUpdated":null,"dateLastComment":"2022-09-26T19:47:34+00:00","insertUserID":152316,"insertUser":{"userID":152316,"name":"Christian G.","url":"https:\/\/community.smartsheet.com\/profile\/Christian%20G.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-26T19:46:28+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":152316,"lastUser":{"userID":152316,"name":"Christian G.","url":"https:\/\/community.smartsheet.com\/profile\/Christian%20G.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-26T19:46:28+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":30,"score":null,"hot":3328168428,"url":"https:\/\/community.smartsheet.com\/discussion\/95848\/numerical-value-of-character","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/95848\/numerical-value-of-character","format":"Rich","lastPost":{"discussionID":95848,"commentID":344896,"name":"Re: Numerical value of character","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/344896#Comment_344896","dateInserted":"2022-09-26T19:47:34+00:00","insertUserID":152316,"insertUser":{"userID":152316,"name":"Christian G.","url":"https:\/\/community.smartsheet.com\/profile\/Christian%20G.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-26T19:46:28+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-09-26T19:46:48+00:00","dateAnswered":"2022-09-26T19:24:18+00:00","acceptedAnswers":[{"commentID":344882,"body":"

Hello, there doesn't appear to be a Smartsheet function<\/a> which does this on it's own. However, you could write your own using INDEX<\/a>, MATCH<\/a> and cross sheet references<\/a>.<\/p>

Create a \"table sheet\" with one column of characters and another column representing their number value. Then in the sheet where you'd like to have the translations done - set up cross sheet references for each of those two columns. Your formula for translating letters to numbers would look something like this:<\/p>

INDEX({NumValue}, (MATCH(Value@row, {Char Values}, 0)))<\/code><\/p>

Hope this helps!<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-09-26 19:46:49","updateUser":{"userID":152316,"name":"Christian G.","url":"https:\/\/community.smartsheet.com\/profile\/Christian%20G.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-26T19:46:28+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]}],"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">