添加Ons和集成

询问有关控制中心、动态视图、数据网、轴心应用程序、日历应用程序、工作应用程序或资源管理的问题。讨论如何使用Bridge、Data Shuttle、Jira连接器和Salesforce连接器等集成将Smartsheet连接到其他系统。

讨论表

You would need to insert a Date type column and then use<\/p>

=DATEONLY([Created Date Column Name]@row)<\/p>


<\/p>

You can then reference this new date column in your automation setup.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2023-02-10 09:30:04","updateUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-02-13T14:31:23+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}}},"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":100985,"type":"question","name":"Customized Workflow Notifications","excerpt":"I am investigating the use of workflow notifications. In my sheet I have a parent row with a row for the Project Name. Each child row has the Task name. They use the same column. I am wondering if it is possible to refer to the parent (Project Name) in a notification for a child task in the notification message content.…","categoryID":321,"dateInserted":"2023-02-10T16:05:55+00:00","dateUpdated":null,"dateLastComment":"2023-02-10T16:32:33+00:00","insertUserID":106346,"insertUser":{"userID":106346,"name":"Pamb10","url":"https:\/\/community.smartsheet.com\/profile\/Pamb10","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-02-10T16:31:53+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":106346,"lastUser":{"userID":106346,"name":"Pamb10","url":"https:\/\/community.smartsheet.com\/profile\/Pamb10","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-02-10T16:31:53+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":27,"score":null,"hot":3352093108,"url":"https:\/\/community.smartsheet.com\/discussion\/100985\/customized-workflow-notifications","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/100985\/customized-workflow-notifications","format":"Rich","lastPost":{"discussionID":100985,"commentID":361772,"name":"Re: Customized Workflow Notifications","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/361772#Comment_361772","dateInserted":"2023-02-10T16:32:33+00:00","insertUserID":106346,"insertUser":{"userID":106346,"name":"Pamb10","url":"https:\/\/community.smartsheet.com\/profile\/Pamb10","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-02-10T16:31:53+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":"2023-02-10T16:32:36+00:00","dateAnswered":"2023-02-10T16:28:47+00:00","acceptedAnswers":[{"commentID":361771,"body":"

Hi @Pamb10<\/a> <\/p>

It is but you will need to use a hidden helper column, please see example below. As notifications are row based and would be triggered based on activity in the child row, you simply need to bring the parent row project name down to each row.<\/p>

\n
\n \n \"image.png\"<\/img><\/a>\n <\/div>\n<\/div>\n

Formula for copying - =PARENT(Parent@row)<\/p>

\n
\n \n \"image.png\"<\/img><\/a>\n <\/div>\n<\/div>\n

You can then reference the Helper column in your notifications against the child tasks as and when triggered<\/p>

Hope that helps<\/p>

Thanks<\/p>

Paul<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2023-02-10 16:32:36","updateUser":{"userID":106346,"name":"Pamb10","url":"https:\/\/community.smartsheet.com\/profile\/Pamb10","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-02-10T16:31:53+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":100984,"type":"question","name":"How do I provide access to a Form to all the project managers?","excerpt":"I've setup a \"new project intake sheet\" with a Form so that any PM can input a proposed new project. The form works fine and the sheet populates correctly. However, I cannot find the Form unless I first open the Sheet and select Forms, Manage Forms, Open Form. There must be a more direct way to get to the form besides…","categoryID":321,"dateInserted":"2023-02-10T15:48:42+00:00","dateUpdated":null,"dateLastComment":"2023-02-10T16:09:06+00:00","insertUserID":154725,"insertUser":{"userID":154725,"name":"Chadd","url":"https:\/\/community.smartsheet.com\/profile\/Chadd","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pqko6duovko!3LFmv1eQDPo!X_wa7iThLkQ","dateLastActive":"2023-02-10T22:15:49+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":154725,"lastUser":{"userID":154725,"name":"Chadd","url":"https:\/\/community.smartsheet.com\/profile\/Chadd","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pqko6duovko!3LFmv1eQDPo!X_wa7iThLkQ","dateLastActive":"2023-02-10T22:15:49+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":37,"score":null,"hot":3352090668,"url":"https:\/\/community.smartsheet.com\/discussion\/100984\/how-do-i-provide-access-to-a-form-to-all-the-project-managers","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/100984\/how-do-i-provide-access-to-a-form-to-all-the-project-managers","format":"Rich","lastPost":{"discussionID":100984,"commentID":361762,"name":"Re: How do I provide access to a Form to all the project managers?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/361762#Comment_361762","dateInserted":"2023-02-10T16:09:06+00:00","insertUserID":154725,"insertUser":{"userID":154725,"name":"Chadd","url":"https:\/\/community.smartsheet.com\/profile\/Chadd","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pqko6duovko!3LFmv1eQDPo!X_wa7iThLkQ","dateLastActive":"2023-02-10T22:15:49+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":"2023-02-10T16:02:48+00:00","dateAnswered":"2023-02-10T15:58:38+00:00","acceptedAnswers":[{"commentID":361760,"body":"

Hi @Chadd<\/a> <\/p>

You're not missing anything. Accessing the Form can be a bit of a mystery at first. Obviously emailing a link always works but I prefer to embed the form on a dashboard and share the dashboard with the users. Whether you embed the form itself or add the link as a shortcut widget, the user can favorite that dashboard for quick access. This method works especially well on a mobile device.<\/p>

Or if there's a different dashboard that the users frequently access, you could add the link to that as well.<\/p>

I hope that helps.<\/p>

Matt<\/p>"},{"commentID":361762,"body":"

Thanks that helps. We do not yet have any dashboards setup but I guess I could create one specifically for this purpose. Or, I can send an email with a link but then they need to keep that email flagged and available to use the link I guess. This seems very odd and clunky to me. Why not just have Forms appear in their workspace\/folder like a Sheet does... Oh well.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2023-02-10 16:02:48","updateUser":{"userID":154725,"name":"Chadd","url":"https:\/\/community.smartsheet.com\/profile\/Chadd","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pqko6duovko!3LFmv1eQDPo!X_wa7iThLkQ","dateLastActive":"2023-02-10T22:15:49+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":[]}">