只共享某些列

比尔哈里斯
比尔哈里斯 ✭
在内容基本知识

下午好

我想能够与分包商只共享一页选定的列。

所以我创建了一个报告，添加了两列…但是承包者不能看到任何数据，因为他没有被共享到底层工作表。

我不能把他透露给下面的文件，这是机密

我可以发表报告，但他不能编辑……

有什么建议吗?

标签:

答案

  • 她名叫Stara
    她名叫Stara ✭✭✭✭✭✭

    嗨@Bill哈里斯

    我希望你一切安好!

    你有什么智能表计划?如果您拥有Enterprise或更高版本，您可以使用新的WorkApps解决方案。

    这是一种选择吗?

    我希望这能有所帮助!

    注意安全，祝你周末愉快!

    最好的

    她名叫Stara|工作流顾问/ CEO @工作大胆

    ✅我的帖子是否帮助或回答了你的问题或解决了你的问题?请帮助社区把它标记为可接受的答案/有帮助．这将使别人更容易找到解决方案或帮助回答!

    Smartsheet专家顾问和合作伙伴

    https://workbold.com/

    她名叫Stara|工作流顾问/ CEO @工作大胆

    W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35

    请随时联系我有关Smartsheet的帮助，集成，一般的工作流程建议，或其他完全的东西。

  • 比尔哈里斯
    比尔哈里斯 ✭

    你好@Andree Stara

    我们使用商业计划

  • McAfee电气经理
    McAfee电气经理 ✭

    @她名叫Stara我也想做同样的事。我有企业计划，但我假设只有“用户”可以访问应用程序，你必须购买一个额外的计划，以允许合作者访问。现在还是这样吗?

类别

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-09-30T18:35:04+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-01T01:05:16+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":18,"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-01T01:05:16+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"}]},{"discussionID":96019,"type":"question","name":"What does \"up to 30 configurations\" mean in Dynamic View?","excerpt":"Hello, My company's account has the Dynamic View Add-On\/Integration feature and our contract states that our Dynamic View feature has \"up to 30 configurations\". My team is trying to understand what \"up to 30 configurations\" means in Dynamic View. We currently have more than 30 Dynamic Views that we have created, so it is…","categoryID":343,"dateInserted":"2022-09-28T19:00:39+00:00","dateUpdated":"2022-09-28T19:01:19+00:00","dateLastComment":"2022-09-29T20:20:19+00:00","insertUserID":145028,"insertUser":{"userID":145028,"name":"DesireeJones","url":"https:\/\/community.smartsheet.com\/profile\/DesireeJones","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-30T17:41:59+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":145028,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2022-09-30T18:38:30+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":40,"score":null,"hot":3328878058,"url":"https:\/\/community.smartsheet.com\/discussion\/96019\/what-does-up-to-30-configurations-mean-in-dynamic-view","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96019\/what-does-up-to-30-configurations-mean-in-dynamic-view","format":"Rich","tagIDs":[277,443],"lastPost":{"discussionID":96019,"commentID":345422,"name":"Re: What does \"up to 30 configurations\" mean in Dynamic View?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/345422#Comment_345422","dateInserted":"2022-09-29T20:20:19+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2022-09-30T18:38:30+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":"2022-09-29T14:29:00+00:00","dateAnswered":"2022-09-29T13:07:44+00:00","acceptedAnswers":[{"commentID":345364,"body":"

@DesireeJones<\/a> If you have Smartsheet Advanced then they will allow you to create more than 30, but they will upgrade you to another level when it comes time to renew. I would suggest reaching out to your account rep to verify.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-09-29 14:29:00","updateUser":{"userID":145028,"name":"DesireeJones","url":"https:\/\/community.smartsheet.com\/profile\/DesireeJones","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-30T17:41:59+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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":[{"tagID":277,"urlcode":"Integrations","name":"Integrations"},{"tagID":443,"urlcode":"dynamic-view","name":"Dynamic View"}]}],"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">