Data Shuttle
Hello,
I would like add a filter to import Data (Date) which is greater than a date.
Is it possible?
Best Answer
-
Genevieve P. Employee AdminNo, 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. Employee Admin
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 ✭✭✭✭✭
Hi, yes perfect.
And is it possible to put a function? EG: "TODAY-1" instead of a date?
-
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. Employee Admin
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 looks like it just came back up for us (Mid-NC). Crisis averted!<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-10-14 17:00:56","updateUser":{"userID":146258,"name":"dhall","url":"https:\/\/community.smartsheet.com\/profile\/dhall","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!!hynp4UvA47M!xQ8qcU-bLns!nR-64amHDw1","dateLastActive":"2022-10-14T20:19:27+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":96551,"type":"question","name":"When file is uploaded","excerpt":"Is it possible to create an automation (Smartsheet workflow or Power Automate) to send a copy of file to email recipients when file is uploaded to specific row #'s?","categoryID":321,"dateInserted":"2022-10-13T18:29:25+00:00","dateUpdated":null,"dateLastComment":"2022-10-13T19:43:23+00:00","insertUserID":147369,"insertUser":{"userID":147369,"name":"PeggyLang","url":"https:\/\/community.smartsheet.com\/profile\/PeggyLang","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-14T18:19:14+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/f4\/d4\/nf4d40b307033e1c1fd4cfe2ab2c10220.jpg","dateLastActive":"2022-10-14T23:25:52+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":14,"score":null,"hot":3331377768,"url":"https:\/\/community.smartsheet.com\/discussion\/96551\/when-file-is-uploaded","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96551\/when-file-is-uploaded","format":"Rich","lastPost":{"discussionID":96551,"commentID":347128,"name":"Re: When file is uploaded","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/347128#Comment_347128","dateInserted":"2022-10-13T19:43:23+00:00","insertUserID":8888,"insertUser":{"userID":8888,"name":"Andrée Starå","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/f4\/d4\/nf4d40b307033e1c1fd4cfe2ab2c10220.jpg","dateLastActive":"2022-10-14T23:25:52+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-10-13T19:54:33+00:00","dateAnswered":"2022-10-13T19:43:23+00:00","acceptedAnswers":[{"commentID":347128,"body":"
No, that should work as long as the sheet's permissions are okay.<\/p>
