航天飞机的数据
你好,
我想添加一个过滤器来导入数据(日期)，这是大于一个日期。
是可能的吗?
最佳答案
-
吉纳维芙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
类别
No, there currently isn't a way to change the shape of a task in the Calendar App to be a diamond. <\/p>
However you could use the checkbox column as the option in the \"Color By Column\" selection. This means all your Milestone tasks would appear as a different color in your Calendar App. <\/p>
Please submit your feature request to the Product team by creating an Idea Post<\/strong> in the Smartsheet Product Feedback and Ideas topic<\/a> here in the Community. This will allow other users to vote on your enhancement idea!<\/p> Cheers,<\/p> Genevieve<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-10-03 14:34:51","updateUser":{"userID":152895,"name":"Arundhati","url":"https:\/\/community.smartsheet.com\/profile\/Arundhati","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-03T14:57:46+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":96097,"type":"question","name":"Why can't I see 'At Risk' column in sheet summary?","excerpt":"I set up a column 'At Risk' with a formula to flag the rows if the task is past due date and not complete. I am trying to create a dashboard, insert metric widget, sheet summary data and choose the 'At Risk' column but I don't see it. How can I fix this?","categoryID":321,"dateInserted":"2022-09-30T14:42:28+00:00","dateUpdated":null,"dateLastComment":"2022-09-30T16:50:00+00:00","insertUserID":152895,"insertUser":{"userID":152895,"name":"Arundhati","url":"https:\/\/community.smartsheet.com\/profile\/Arundhati","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-03T14:57:46+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-03T15:19:15+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":22,"score":null,"hot":3329107348,"url":"https:\/\/community.smartsheet.com\/discussion\/96097\/why-cant-i-see-at-risk-column-in-sheet-summary","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96097\/why-cant-i-see-at-risk-column-in-sheet-summary","format":"Rich","lastPost":{"discussionID":96097,"commentID":345539,"name":"Re: Why can't I see 'At Risk' column in sheet summary?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/345539#Comment_345539","dateInserted":"2022-09-30T16:50:00+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-03T15:19:15+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-30T16:36:58+00:00","dateAnswered":"2022-09-30T16:17:46+00:00","acceptedAnswers":[{"commentID":345528,"body":" Hi @Arundhati<\/a> <\/p> I hope you're well and safe!<\/p> You can't use the Sheet Summary option if the field for the metric isn't added to the Summary Section.<\/p> Did that work\/help? <\/p> I hope that helps!<\/p> Be safe, and have a fantastic weekend!<\/p> Best,<\/p> Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p> ✅Did my post(s) help or answer your question or solve your problem? Please support the Community by <\/em>marking it Insightful\/Vote Up, Awesome, or\/and as the accepted answer<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-09-30 16:36:58","updateUser":{"userID":152895,"name":"Arundhati","url":"https:\/\/community.smartsheet.com\/profile\/Arundhati","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-03T14:57:46+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":96095,"type":"question","name":"Workflow: Repeat Email Address Instances","excerpt":"I have a column where there are 20+ instances of the same email address. If I create a workflow which sends an alert to all contacts in that column, will it send the alert 20+ times to the same email address? Or does SmartSheet have a failsafe which will only send the alert to that email once?","categoryID":321,"dateInserted":"2022-09-30T14:29:45+00:00","dateUpdated":null,"dateLastComment":"2022-09-30T16:04:32+00:00","insertUserID":146727,"insertUser":{"userID":146727,"name":".Elliott.","url":"https:\/\/community.smartsheet.com\/profile\/.Elliott.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-30T16:20:37+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-03T15:19:15+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":24,"score":null,"hot":3329102657,"url":"https:\/\/community.smartsheet.com\/discussion\/96095\/workflow-repeat-email-address-instances","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96095\/workflow-repeat-email-address-instances","format":"Rich","tagIDs":[448],"lastPost":{"discussionID":96095,"commentID":345523,"name":"Re: Workflow: Repeat Email Address Instances","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/345523#Comment_345523","dateInserted":"2022-09-30T16:04:32+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-03T15:19:15+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-30T16:21:13+00:00","dateAnswered":"2022-09-30T16:04:32+00:00","acceptedAnswers":[{"commentID":345523,"body":" Hi @.Elliott.<\/a> <\/p> I hope you're well and safe!<\/p> They'll be collected in one email, depending on whether you're using the Placeholder feature.<\/p> Placeholders will generate separate notifications when using placeholders with Alert or Update Request actions in change-based workflows if six or fewer rows are triggered simultaneously. The custom subject and body will be removed if seven or more rows are triggered at once.<\/em><\/p> Would that work\/help? <\/p> I hope that helps!<\/p> Be safe, and have a fantastic weekend!<\/p> Best,<\/p> Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p> ✅Did my post(s) help or answer your question or solve your problem? Please support the Community by <\/em>marking it Insightful\/Vote Up, Awesome, or\/and as the accepted answer<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-09-30 16:21:13","updateUser":{"userID":146727,"name":".Elliott.","url":"https:\/\/community.smartsheet.com\/profile\/.Elliott.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-30T16:20:37+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":[{"tagID":448,"urlcode":"workflows-in-smartsheet","name":"Workflows in Smartsheet"}]}],"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">
