航天飞机的数据
你好,
我想添加一个过滤器来导入数据(日期)，这是大于一个日期。
是可能的吗?
最佳答案
-
吉纳维芙P。 员工管理不，我不相信你可以在过滤器中使用TODAY，它需要一个UTC日期。但是，您可以在源表中添加一个列，其中包含一个公式来识别所需的条件，然后根据这个公式的输出过滤DataShuttle工作流。
至于列名，您可以在源数据和Smartsheet中使用不同的列名，但是您只需要确保在工作流的Mapping部分中将正确的列名相互映射。
欢呼,
吉纳维芙
0
答案
-
吉纳维芙P。 员工管理
是的，您可以使用Data Shuttle中的Filter选项卡根据日期进行筛选，但是日期需要以UTC格式输入:(YYYY-MM-DD)
尝试在Data Shuttle中将格式调整为:2021年1月1日
欢呼,
吉纳维芙
0 -
Eric Laitenberger ✭✭✭✭✭
嗨,是的完美。
有可能把一个函数代入吗?例如:“TODAY-1”而不是日期?
0 -
Eric Laitenberger ✭✭✭✭✭
对不起，我还有一个问题。
如果我想移动一行根据标准从表到另一个:
我们必须在这些表格中使用相同的列名吗?
0 -
吉纳维芙P。 员工管理
不，我不相信你可以在过滤器中使用TODAY，它需要一个UTC日期。但是，您可以在源表中添加一个列，其中包含一个公式来识别所需的条件，然后根据这个公式的输出过滤DataShuttle工作流。
至于列名，您可以在源数据和Smartsheet中使用不同的列名，但是您只需要确保在工作流的Mapping部分中将正确的列名相互映射。
欢呼,
吉纳维芙
0
类别
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> 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":[]}">INDEX({NumValue}, (MATCH(Value@row, {Char Values}, 0)))<\/code><\/p>
