向团队发布工作表
你好,
我有两个可能相关的问题。我们的机构广泛使用Teams，所以我想将Smartsheet Dashboards和Sheets集成到Teams中。我将不属于我的组织的用户添加到仪表板和工作表中，发布了仪表板，并向工作表上的外部用户提供了编辑权限。然后我在团队中集成了仪表板和表格。仪表板成功集成，但是用户看到工作表的错误消息(参见截图-团队错误，“发布的项目仅供组织中的用户访问”)。用户不在浏览器上收到此错误-他们可以像正常一样查看和编辑工作表。
在Smartsheet上，我没有发布工作表的选项(见截图-文件选项)，所以我无法更新访问控制。我已经仔细检查了我们的管理设置-表发布是启用的(发布的表提供给任何人与链接)。
这是团队的内部设置吗?如何让外部用户直接在Teams中编辑工作表?
谢谢你！
答案
-
凯文•史密斯 ✭✭✭✭✭✭嗨
请查看Admin设置。我们也经常使用Teams。我们允许任何有链接的人访问报告和仪表板。这只允许链接工作。但是，对于表单，如果外部任何人想要访问表单，我将它们设置在我们的帐户中。
我希望这有帮助，如果你可以改变和测试，它不工作，请让我知道。
谢谢你！
凯文
如果可以，我很乐意帮忙。
☑️你对我对你问题的回答满意吗?请帮助社区将其标记为（接受的回答)
-
艾娃 ✭
谢谢凯文-我已经检查了我们的管理设置和链接共享是打开的(每个人都可以编辑)。还有别的地方可以切换吗?
我觉得很奇怪，我的用户只在Teams选项卡中出现错误——他们可以在浏览器中查看和编辑工作表。
-
凯文•史密斯 ✭✭✭✭✭✭
在工作表上，查看是否可以使用右侧的发布图标发布它。
谢谢你！
凯文
如果可以，我很乐意帮忙。
☑️你对我对你问题的回答满意吗?请帮助社区将其标记为（接受的回答)
-
艾娃 ✭
嗨，凯文-谢谢，我错过了表单上的发布按钮!但它是在打开“任何人编辑”的情况下出版的。也许这是Teams集成中的一个bug ?
-
凯文•史密斯 ✭✭✭✭✭✭
它可能是，我只是不这么认为，因为你的屏幕截图中的错误看起来像一个Smartsheet错误。
我很抱歉那没起作用。
谢谢你！
凯文
如果可以，我很乐意帮忙。
☑️你对我对你问题的回答满意吗?请帮助社区将其标记为（接受的回答)
类别
https:\/\/help.smartsheet.com\/articles\/2482082-configure-grouping-to-organize-results-in-report-builder<\/a><\/p>"},{"commentID":382036,"body":" That is only for grouping. If you are not grouping, there should be a small link if you scroll all the way to the bottom of the report to go to the next page.<\/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"}]},{"discussionID":106837,"type":"question","name":"All columns aren't showing up for Grouping in Reports","excerpt":"I'm pretty new to Smartsheet and can't figure out what I am doing wrong here. I am trying to Group by the \"PM\" column but it's not showing up in the list. It's formatted as a dropdown, but other columns that are appearing on the list are formatted the same way. What am I doing wrong? Thanks!","categoryID":321,"dateInserted":"2023-06-23T15:59:37+00:00","dateUpdated":"2023-06-23T16:10:12+00:00","dateLastComment":"2023-06-23T17:07:03+00:00","insertUserID":161580,"insertUser":{"userID":161580,"name":"LDP","title":"Sr. Business Analyst","url":"https:\/\/community.smartsheet.com\/profile\/LDP","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-23T17:47:34+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":161580,"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":"2023-06-23T18:27:02+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":21,"score":null,"hot":3375076600,"url":"https:\/\/community.smartsheet.com\/discussion\/106837\/all-columns-arent-showing-up-for-grouping-in-reports","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106837\/all-columns-arent-showing-up-for-grouping-in-reports","format":"Rich","lastPost":{"discussionID":106837,"commentID":382035,"name":"Re: All columns aren't showing up for Grouping in Reports","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/382035#Comment_382035","dateInserted":"2023-06-23T17:07:03+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":"2023-06-23T18:27:02+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\/2EJA60U6S04F\/pm-column-issue.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"PM Column Issue.jpg"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-23T17:47:52+00:00","dateAnswered":"2023-06-23T17:07:03+00:00","acceptedAnswers":[{"commentID":382035,"body":" Is it set to allow for multiple selections? If so, reports cannot group by that. The only way to get it to work on a dropdown column is if it is set as a single select.<\/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":106777,"type":"question","name":"Struggling with Notification Preferences","excerpt":"I have a user with the following configuration: Two automations are defined: 1 - Trigger: When rows are changed. Alert Someone - Send to Specific People (contacts provided) 2 - Trigger: When rows are added or changed. Alert Someone- Send to Specific People (contacts provided) There is no problem with the notifications…","categoryID":321,"dateInserted":"2023-06-22T15:42:37+00:00","dateUpdated":null,"dateLastComment":"2023-06-23T16:18:18+00:00","insertUserID":137494,"insertUser":{"userID":137494,"name":"LWright","title":"","url":"https:\/\/community.smartsheet.com\/profile\/LWright","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/nCDGV1TJ8PEJV.png","dateLastActive":"2023-06-23T19:02:46+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":137494,"lastUser":{"userID":137494,"name":"LWright","title":"","url":"https:\/\/community.smartsheet.com\/profile\/LWright","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/nCDGV1TJ8PEJV.png","dateLastActive":"2023-06-23T19:02:46+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":49,"score":null,"hot":3374989855,"url":"https:\/\/community.smartsheet.com\/discussion\/106777\/struggling-with-notification-preferences","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106777\/struggling-with-notification-preferences","format":"Rich","lastPost":{"discussionID":106777,"commentID":382017,"name":"Re: Struggling with Notification Preferences","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/382017#Comment_382017","dateInserted":"2023-06-23T16:18:18+00:00","insertUserID":137494,"insertUser":{"userID":137494,"name":"LWright","title":"","url":"https:\/\/community.smartsheet.com\/profile\/LWright","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/nCDGV1TJ8PEJV.png","dateLastActive":"2023-06-23T19:02:46+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\/EC5H22Y159GM\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-23T18:52:23+00:00","dateAnswered":"2023-06-23T00:00:45+00:00","acceptedAnswers":[{"commentID":381885,"body":" Seems like a bug, I’d reach out to Support.<\/p>"},{"commentID":382008,"body":"
