如何将Outlook日历嵌入到Smartsheet仪表板中?

我想要一个包含多个Outlook日历的Smartsheet仪表板。我试着使用Outlook共享链接,但Smartsheet给了我一个错误,说“我们无法从这个链接中找到任何可嵌入的内容”。是否有可能将Outlook日历嵌入到Smartsheet仪表板中?如果有,怎么做?

最佳答案

答案

=IF(MONTH(Date@row) = MONTH(TODAY()), \"This Month\", \"Last Month\")<\/p>

You were on the right track.<\/p>

Will the current and previous months be the only options? Will there be entries from prior to last month?<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"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":106120,"type":"question","name":"PDF Attachment Downloads","excerpt":"We used to be able to click one time on the PDF symbol to open our documents, but now have to click on the three dots and then get this menu and select open in new tab. The single click still works if we are opening a Word document, just not with PDF. Is there a way to get this function back?","categoryID":321,"dateInserted":"2023-06-07T10:34:01+00:00","dateUpdated":"2023-06-07T10:38:21+00:00","dateLastComment":"2023-06-07T13:43:04+00:00","insertUserID":162132,"insertUser":{"userID":162132,"name":"Renee1_CRA","url":"https:\/\/community.smartsheet.com\/profile\/Renee1_CRA","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-07T13:46:45+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-06-07T18:22:11+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":29,"score":null,"hot":3372281225,"url":"https:\/\/community.smartsheet.com\/discussion\/106120\/pdf-attachment-downloads","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106120\/pdf-attachment-downloads","format":"Rich","lastPost":{"discussionID":106120,"commentID":379260,"name":"Re: PDF Attachment Downloads","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379260#Comment_379260","dateInserted":"2023-06-07T13:43:04+00:00","insertUserID":91566,"insertUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-06-07T18:22:11+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}},"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,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/H01NI7XP81IL\/screenshot-2023-06-07-at-11-38-08.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screenshot 2023-06-07 at 11.38.08.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-07T13:48:56+00:00","dateAnswered":"2023-06-07T13:43:04+00:00","acceptedAnswers":[{"commentID":379260,"body":"

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

If you don't want to select the option from the dropdown menu, you can use keyboard shortcuts to open the file in a new tab as well: Ctrl+Click<\/strong> (Windows) or CMD+Click <\/strong>(Mac).<\/p>

Cheers,<\/p>

Genevieve<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"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":106077,"type":"question","name":"Percentages not displaying correctly in Report Summary","excerpt":"Hi, In this report. I want to total up a number of percentages coming from different sheets. Sometimes the percentages add up as percentages, sometimes they display as an fraction. The source sheets are all from the same template, so should be formatted the same way, though I have noticed that certain files seem to be…","categoryID":321,"dateInserted":"2023-06-06T16:57:43+00:00","dateUpdated":null,"dateLastComment":"2023-06-07T14:55:02+00:00","insertUserID":161188,"insertUser":{"userID":161188,"name":"RRM","title":"Mr","url":"https:\/\/community.smartsheet.com\/profile\/RRM","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!nrDn__-bHHo!-ilmN2fAGAI!vHUL5VGglpN","dateLastActive":"2023-06-07T14:54:08+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":161188,"lastUser":{"userID":161188,"name":"RRM","title":"Mr","url":"https:\/\/community.smartsheet.com\/profile\/RRM","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!nrDn__-bHHo!-ilmN2fAGAI!vHUL5VGglpN","dateLastActive":"2023-06-07T14:54:08+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":31,"score":null,"hot":3372222765,"url":"https:\/\/community.smartsheet.com\/discussion\/106077\/percentages-not-displaying-correctly-in-report-summary","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106077\/percentages-not-displaying-correctly-in-report-summary","format":"Rich","tagIDs":[265],"lastPost":{"discussionID":106077,"commentID":379287,"name":"Re: Percentages not displaying correctly in Report Summary","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379287#Comment_379287","dateInserted":"2023-06-07T14:55:02+00:00","insertUserID":161188,"insertUser":{"userID":161188,"name":"RRM","title":"Mr","url":"https:\/\/community.smartsheet.com\/profile\/RRM","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!nrDn__-bHHo!-ilmN2fAGAI!vHUL5VGglpN","dateLastActive":"2023-06-07T14:54:08+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,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/9KBOWFBASG02\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-07T14:54:05+00:00","dateAnswered":"2023-06-07T11:56:42+00:00","acceptedAnswers":[{"commentID":379219,"body":"

Hi @RRM<\/a> and @Kleerfyre<\/a> <\/p>

The Support team received other reports of this same behaviour yesterday and were able to identify the cause; this should now be resolved! Please refresh your Report and you should see your percentages appear in the Summary rows again.<\/p>

Cheers,<\/p>

Genevieve<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"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":265,"urlcode":"Reports","name":"Reports"}]}],"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

使用Smartsheet的趋势