同步智能表日历与Outlook日历

Allison主教
Allison主教 ✭✭✭✭✭
在内容基本知识

你好,

我正在寻找有关如何同步您的SmartSheet日历与您的outlook日历的最新和最好的培训信息。如果有人能帮忙，请告诉我。

谢谢你！

Allison主教

标签:
· 在Facebook上分享 在Twitter上分享

最好的答案

答案

类别

You would need to insert a helper column (checkbox is recommended) that has a formula in it to automatically check the box when the other row is marked 100%. You would then set up your automation to run based on this box being checked.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-10-20 20:35:40","updateUser":{"userID":147643,"name":"Anthony DAmbrosio","url":"https:\/\/community.smartsheet.com\/profile\/Anthony%20DAmbrosio","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-20T20:35:16+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":96823,"type":"question","name":"Simplify Approval process","excerpt":"I have a form where the user submits a request and chooses the affected department. I would like smartsheet to assign the task to a specific person based on the affected dept, and send them an approval request. I have created a table in a separate sheet that could be referenced. Is there a function in the automation that…","categoryID":321,"dateInserted":"2022-10-20T11:57:49+00:00","dateUpdated":null,"dateLastComment":"2022-10-20T12:04:05+00:00","insertUserID":153914,"insertUser":{"userID":153914,"name":"MikeEngr","url":"https:\/\/community.smartsheet.com\/profile\/MikeEngr","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-20T19:48:54+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":152316,"lastUser":{"userID":152316,"name":"Christian G.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Christian%20G.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-20T19:03:23+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":22,"score":null,"hot":3332535114,"url":"https:\/\/community.smartsheet.com\/discussion\/96823\/simplify-approval-process","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96823\/simplify-approval-process","format":"Rich","lastPost":{"discussionID":96823,"commentID":347915,"name":"Re: Simplify Approval process","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/347915#Comment_347915","dateInserted":"2022-10-20T12:04:05+00:00","insertUserID":152316,"insertUser":{"userID":152316,"name":"Christian G.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Christian%20G.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-20T19:03:23+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-20T15:04:55+00:00","dateAnswered":"2022-10-20T12:04:05+00:00","acceptedAnswers":[{"commentID":347915,"body":"

You can use a formula to get the right person to assign. And an automation to send the approval to the person assign.<\/p>

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


<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-10-20 15:04:55","updateUser":{"userID":153914,"name":"MikeEngr","url":"https:\/\/community.smartsheet.com\/profile\/MikeEngr","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-20T19:48:54+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":96789,"type":"question","name":"Milestone summary pie chart across multiple sheets","excerpt":"I am looking to create a pie chart that shows the total number of milestones on track, in progress, not started, etc. across multiple sheets. I have all the same formulas in the Sheet Summary tab across all the sheets, and they are pulled into one report. And, I have the columns summarized on the sheet summary report. Is…","categoryID":321,"dateInserted":"2022-10-19T16:38:06+00:00","dateUpdated":null,"dateLastComment":"2022-10-20T13:38:27+00:00","insertUserID":153595,"insertUser":{"userID":153595,"name":"NBW501","url":"https:\/\/community.smartsheet.com\/profile\/NBW501","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-20T17:34:03+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":153595,"lastUser":{"userID":153595,"name":"NBW501","url":"https:\/\/community.smartsheet.com\/profile\/NBW501","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-20T17:34:03+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":37,"score":null,"hot":3332472993,"url":"https:\/\/community.smartsheet.com\/discussion\/96789\/milestone-summary-pie-chart-across-multiple-sheets","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96789\/milestone-summary-pie-chart-across-multiple-sheets","format":"Rich","lastPost":{"discussionID":96789,"commentID":347959,"name":"Re: Milestone summary pie chart across multiple sheets","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/347959#Comment_347959","dateInserted":"2022-10-20T13:38:27+00:00","insertUserID":153595,"insertUser":{"userID":153595,"name":"NBW501","url":"https:\/\/community.smartsheet.com\/profile\/NBW501","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-20T17:34:03+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-20T13:38:33+00:00","dateAnswered":"2022-10-20T13:38:27+00:00","acceptedAnswers":[{"commentID":347959,"body":"

Accepted Answer: <\/p>