只共享某些列

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

下午好

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

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

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

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

有什么建议吗?

标签:

答案

  • 她名叫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 @meb_0101<\/a> <\/p>

I hope you're well and safe!<\/p>

Unfortunately, as far as I know, it's not possible now, but it's an excellent idea!<\/p>

Please submit this as a Product Feedback or Idea <\/strong>(If it hasn't been added already)<\/em><\/strong> when you have a moment.<\/strong><\/a><\/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-10-07 16:01:57","updateUser":{"userID":153311,"name":"meb_0101","url":"https:\/\/community.smartsheet.com\/profile\/meb_0101","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-07T21:06: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":[{"tagID":204,"urlcode":"Forms","name":"Forms"},{"tagID":228,"urlcode":"Project Management","name":"Project Management"}]},{"discussionID":96303,"type":"question","name":"Where are company generated emails stored or pulled from?","excerpt":"Where does SmartSheet pull our company email addresses from? We have a situation where an employee who is no longer with us has the same email address as another active employee. When our active employee submits a form in SmartSheet, the incorrect email address associated with the former employee is being used to send an…","categoryID":321,"dateInserted":"2022-10-06T15:18:01+00:00","dateUpdated":"2022-10-06T19:30:55+00:00","dateLastComment":"2022-10-06T18:46:56+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-10-07T12:16:49+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":150538,"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\/NDZ9JFCTQ8E3\/n8CCYP0Y12F8V.png","dateLastActive":"2022-10-08T11:51:52+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":true,"countComments":5,"countViews":58,"score":null,"hot":3330154497,"url":"https:\/\/community.smartsheet.com\/discussion\/96303\/where-are-company-generated-emails-stored-or-pulled-from","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96303\/where-are-company-generated-emails-stored-or-pulled-from","format":"Rich","tagIDs":[204],"lastPost":{"discussionID":96303,"commentID":346347,"name":"Re: Where are company generated emails stored or pulled from?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/346347#Comment_346347","dateInserted":"2022-10-06T18:46:56+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\/NDZ9JFCTQ8E3\/n8CCYP0Y12F8V.png","dateLastActive":"2022-10-08T11:51:52+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,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-10-06T18:47:09+00:00","dateAnswered":"2022-10-06T18:46:56+00:00","acceptedAnswers":[{"commentID":346334,"body":"

Hello @Mike TV<\/a> ,<\/p>

Thank you for your prompt and legitimate replies and your spectacular patience. <\/p>

I understand how the SmartSheet community works, thank you for your intense consideration.<\/p>

To answer your reply and legitimate question, it seems the company reused the email address and allocated it to a different employee. So we are trying to figure out where SmartSheet is pulling the information from. <\/p>

Thanks!<\/p>"},{"commentID":346347,"body":"

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

An email address can only be associated with one Smartsheet account at a time. This means that if your new Employee logs in to Smartsheet with a duplicate email, the account they're logging in to will be the previous Employee's account. <\/p>

You can manage members of your Smartsheet plan by accessing the User Management page in the Admin Center, that @Mike TV<\/a> linked to. Here's another article that you may find helpful! Admin Center: Add, edit, or delete users<\/a><\/p>

If your email alerts have the wrong name associated with the email, this is likely due to the Smartsheet name associated with that account. A System Admin can adjust this (see the article above) or the new Employee can change this in their personal settings: Adjust your personal account settings<\/a><\/p>

Let me know if this helped! If not, it may be useful to see screen captures showing the areas where you see discrepancies, but please block out sensitive data. <\/p>

Thanks,<\/p>

Genevieve<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-10-06 18:47:09","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-10-07T12:16: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":[{"tagID":204,"urlcode":"Forms","name":"Forms"}]},{"discussionID":96277,"type":"question","name":"Trying to yield results only if a date is in between two dates","excerpt":"=IF([Q1 End Date]1 > [Target Service Start Date]6 < [Q1 Start Date]1, \"true\", \"false\") This is the formula I tried. =IF([Target Service Start Date]6 <[Q1 End Date]1 > [Q1 Start Date]1, \"true\", \"false\") I also tried this.. still not working. I am trying to say if [Target Service Start Date] falls between [Q1 Start Date] and…","categoryID":321,"dateInserted":"2022-10-05T21:02:07+00:00","dateUpdated":null,"dateLastComment":"2022-10-06T19:36:43+00:00","insertUserID":152884,"insertUser":{"userID":152884,"name":"mtetzlaf","url":"https:\/\/community.smartsheet.com\/profile\/mtetzlaf","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-07T16:02:14+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":67611,"lastUser":{"userID":67611,"name":"Michael Culley","url":"https:\/\/community.smartsheet.com\/profile\/Michael%20Culley","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/9BX019BZTFOW\/n0CCMUI3GCT23.jpg","dateLastActive":"2022-10-07T19:21:49+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":34,"score":null,"hot":3330091730,"url":"https:\/\/community.smartsheet.com\/discussion\/96277\/trying-to-yield-results-only-if-a-date-is-in-between-two-dates","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96277\/trying-to-yield-results-only-if-a-date-is-in-between-two-dates","format":"Rich","lastPost":{"discussionID":96277,"commentID":346353,"name":"Re: Trying to yield results only if a date is in between two dates","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/346353#Comment_346353","dateInserted":"2022-10-06T19:36:43+00:00","insertUserID":67611,"insertUser":{"userID":67611,"name":"Michael Culley","url":"https:\/\/community.smartsheet.com\/profile\/Michael%20Culley","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/9BX019BZTFOW\/n0CCMUI3GCT23.jpg","dateLastActive":"2022-10-07T19:21: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":"2022-10-06T19:28:23+00:00","dateAnswered":"2022-10-06T13:26:13+00:00","acceptedAnswers":[{"commentID":346256,"body":"

Try this:<\/p>

=IF(AND([Target Service Start Date]6 <[Q1 End Date]1,[Target Service Start Date]6 > [Q1 Start Date]1), \"true\", \"false\")<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-10-06 19:28:24","updateUser":{"userID":150538,"name":"Preston P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Preston%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/nWVKDFTEFOKBN.png","dateLastActive":"2022-10-06T22:28:36+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":[]}],"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">