将日历视图嵌入到汇流页

藤本植物林
藤本植物林 ✭
编辑06/14/22 在添加插件和集成

是否可以将日历视图从智能工作表嵌入到汇流页面?希望能够在智能表中维护事件日历，并在Confluence中更新。

谢谢!

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

答案

类别

Hi @ChrisNHS<\/a>,<\/p>

ok, so they need to be able to edit data they see in the report?<\/p>

And you don't want them to be able to see the whole source sheet?<\/p>

\n \n \/\/www.santa-greenland.com\/marketplace\/premium-apps\/dynamic-view\n <\/a>\n<\/div>

Depending on your actual use case there are some options. As Sing Chen already wrote, you could use the premium add-on \"Dynamic View\". It allows to create views onto your data with totally individual edit rights. Makes sense only, if you use this not just for one person but for let's say a sales organisation where people from various locations should work on a HQ sales sheet without access to the data from other people.<\/p>

\n \n \/\/www.santa-greenland.com\/datasheets\/datasheet-workapps\n <\/a>\n<\/div>

You could probably build a WorkApp. WorkApps usually also require extra license cost. <\/p>

If the data in your report shows a set of rows from your source sheet that does not change (e.g. a part of a bigger project plan), then you could use a sheet with duplicates of those rows, link the cells from the original sheet to the duplicate and make the duplicate the source of your report. Place it where the report user has access and there you go.<\/p>

Hope some of this makes sense for you.<\/p>

Stefan<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2023-02-23 11:23:55","updateUser":{"userID":156250,"name":"ChrisNHS","url":"https:\/\/community.smartsheet.com\/profile\/ChrisNHS","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!zE8uM0oRwHo!w0kttzIGOLo!4667gNxMjex","dateLastActive":"2023-02-23T11:39:51+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":101591,"type":"question","name":"Auto-notification emails","excerpt":"I have set an auto-notification email to be sent out when a new incident is entered into our system. However the email shows in the email subject, etc that it was sent from me. Is there a way to show that it was sent from Smartsheet (and not from me specifically)?","categoryID":321,"dateInserted":"2023-02-23T01:00:56+00:00","dateUpdated":null,"dateLastComment":"2023-02-23T12:00:35+00:00","insertUserID":153123,"insertUser":{"userID":153123,"name":"jacquedale","url":"https:\/\/community.smartsheet.com\/profile\/jacquedale","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-02-23T01:37:15+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":91566,"lastUser":{"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-23T14:19:25+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":48,"score":null,"hot":3354270691,"url":"https:\/\/community.smartsheet.com\/discussion\/101591\/auto-notification-emails","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/101591\/auto-notification-emails","format":"Rich","lastPost":{"discussionID":101591,"commentID":363851,"name":"Re: Auto-notification emails","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/363851#Comment_363851","dateInserted":"2023-02-23T12:00:35+00:00","insertUserID":91566,"insertUser":{"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-23T14:19:25+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\/W3SKZX3L0I38\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-02-23T01:28:33+00:00","dateAnswered":"2023-02-23T01:24:58+00:00","acceptedAnswers":[{"commentID":363810,"body":"

Hey @jacquedale<\/a> thanks for responding with the image.<\/p>

@ABoado<\/a> seems to have the solution here. This is a fantastic new feature that (hopefully) will be available to everyone soon.<\/p>

I just took a look at some of my notification emails & it seems right now whoever triggered the automation gets displayed as the sender (I was thinking of the message subject when I first replied). So right now joining the EAP seems to be your only solution.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2023-02-23 01:28:33","updateUser":{"userID":153123,"name":"jacquedale","url":"https:\/\/community.smartsheet.com\/profile\/jacquedale","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-02-23T01:37:15+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":101583,"type":"question","name":"Formula to count both names in one cell","excerpt":"Hello, I'm trying to count a total of two different names in a column, A-Mission B=Portfollio\/Mission. This is what I have so far, and I know I'm doing something wrong here. 😆. Please assist, thank you!!! =COUNTIF({Copy of Change Request Range 1}, \"Mission\", COUNTIF({Copy of Change Request Range 1}, \"Portfollio\/Mission\"))","categoryID":343,"dateInserted":"2023-02-22T23:25:38+00:00","dateUpdated":null,"dateLastComment":"2023-02-23T01:05:48+00:00","insertUserID":155716,"insertUser":{"userID":155716,"name":"Nkeiruka. Aguocha","url":"https:\/\/community.smartsheet.com\/profile\/Nkeiruka.%20Aguocha","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-02-22T23:49:12+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":129958,"lastUser":{"userID":129958,"name":"Lucas Rayala","url":"https:\/\/community.smartsheet.com\/profile\/Lucas%20Rayala","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!3C9S_9DsC3w!XMDTX-y-BOY!TEYKqbaL30P","dateLastActive":"2023-02-23T01:03:31+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":23,"score":null,"hot":3354225086,"url":"https:\/\/community.smartsheet.com\/discussion\/101583\/formula-to-count-both-names-in-one-cell","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/101583\/formula-to-count-both-names-in-one-cell","format":"Rich","lastPost":{"discussionID":101583,"commentID":363804,"name":"Re: Formula to count both names in one cell","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/363804#Comment_363804","dateInserted":"2023-02-23T01:05:48+00:00","insertUserID":129958,"insertUser":{"userID":129958,"name":"Lucas Rayala","url":"https:\/\/community.smartsheet.com\/profile\/Lucas%20Rayala","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!3C9S_9DsC3w!XMDTX-y-BOY!TEYKqbaL30P","dateLastActive":"2023-02-23T01:03:31+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":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-02-23T12:53:55+00:00","dateAnswered":"2023-02-22T23:38:07+00:00","acceptedAnswers":[{"commentID":363791,"body":"

Try this:<\/p>

=COUNTIF({Copy of Change Request Range 1}, OR(@cell =\"Mission\", @cell=\"Portfollio\/Mission\"))<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2023-02-23 12:53:54","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-23T14:19:25+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}}},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","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":[]}">