Hide comments in a published report?
Hi there,
Is it possible to hide comments in a publishedreport? I see this is an option when publishing asheetas "Read only - HTML", but this option does not appear to be available when publishing areport. There are comments in our main sheet that the report is built on which we do not want to be visible in the published report.
I know that I can hide the comments column in the report which also hides it in the published report, but someone can still view the comments in the published report for a row by clicking on the row and then clicking the "Conversations" icon.
I do, however, see that adding a report to adashboard删除评论,但接口之类的东西is a bit more clunky. Is this the advised way to accomplish this? Add report via widget to a dashboard, then publish the dashboard? If I do it this way, do users need access to the report in order to see it in a published dashboard?
(I'm on a government tenancy, by the way.)
Thanks!
Jamie
Answers
-
Ben Goldblatt Employee
As you found, when publishing reports you only have theRead Only - Fulloption which does allow for viewing comments. I highly recommendSubmitting a Product Enhancement Requestto include more publishing options on reports, as I can definitely see a use case for restricting comments and attachments in a published version.
Using aReport widgeton a dashboard would produce a snapshot of the reporting data to show the report information without the comments. When you add a Report widget, within theEdit Report widgetwindow you'll see a button for "Advanced Options". Clicking this button will give you options to configure how the data is displayed.
If you want people to see the data in the widget as you are able to see it, and you want it to remain the same for all viewers, no matter who is viewing the dashboard, choose theWidget editoroption. If you selectDashboard viewer, people will need to be shared to the underlying source sheet(s) that are being pulled into the report in order to see the information in the dashboard. More information on these advanced options can be found in the Help article titledControl Widget Content When Source Is From a Report
Another option you could consider would be toshare the report as an attachment via email(PDF or Excel format) to distribute the report without the comments. This could be set up to send out on a recurring basis if needed and the email attachment would only include the cell data from the report. Note though that if you go this route, the recipients would need to download the files to be able to view the information as opposed to viewing the information in one place in a dashboard.
I hope this helps!
Thanks,
Ben
-
pe22 ✭
Does anybody know if this enhancement has been completed yet? It seems silly to publish a report which allows the end users to read through all the comments/conversations. Makes the publishing feature unusable in a lot of scenarios.
-
John Knipper ✭✭✭✭
Still awaiting a response
-
John Knipper ✭✭✭✭
If you hide the comments/attachment columns on the report before the report is published, they are not visible on the published report.
-
@John Knipper-- as I said in my original post, it is ineffective to hide the comments column before publishing the report as a viewer of the Published Report can still see the comments via the Conversations function. This is still true as of today for Government users, at least.
-
kerobi ✭
Does anyone know this enhancement was ever implemented? I've got teams using comments more, as it's a natural thing to do if you're used to commenting in Google Sheets/Excel.
-
Has not yet been implemented as far as I can tell.
-
veastwood7 ✭✭
>Another option you could consider would be toshare the report as an attachment via email(PDF or Excel format) to distribute the report without the comments. This could be set up to send out on a recurring basis if needed and the email attachment would only include the cell data from the report.
This is exactly what I want to do - send an excel report through email, but the conversations end up on another page of the file. We have confidential information in our conversations and would like to make sure they don't go out to customers. Can anyone verify if this is possible?
-
KRichard ✭✭✭
This is a major issue. Does anybody know if it's being developed?
-
Lori Khoury ✭✭✭✭✭
Hi all
Intersted to know if anyone has heard of a work around for this issue and an implemented enhancement ?
Categories
I hope you're well and safe!<\/p>
There's a known issue at the moment.<\/p>
I'll get back to the post if I can find the thread.<\/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"},"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":108880,"type":"question","name":"Recover a Row that was accidentally moved then deleted","excerpt":"I was attempting to copy a row from sheet 1 to sheet 2, but I accidentally moved the row then deleted it, but then realized belatedly that the original (now deleted) data in sheet 1 had been moved. Apparently one can not simply use the \"undo action\" arrow after moving something--the option is grayed out as in not…","snippet":"I was attempting to copy a row from sheet 1 to sheet 2, but I accidentally moved the row then deleted it, but then realized belatedly that the original (now deleted) data in sheet…","categoryID":321,"dateInserted":"2023-08-11T22:27:56+00:00","dateUpdated":null,"dateLastComment":"2023-08-12T05:12:42+00:00","insertUserID":165013,"insertUser":{"userID":165013,"name":"GlennJo","title":"Riparian Stewardship Program Manager","url":"https:\/\/community.smartsheet.com\/profile\/GlennJo","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-12T03:46:04+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":165013,"lastUser":{"userID":165013,"name":"GlennJo","title":"Riparian Stewardship Program Manager","url":"https:\/\/community.smartsheet.com\/profile\/GlennJo","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-12T03:46:04+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":32,"score":null,"hot":3383611238,"url":"https:\/\/community.smartsheet.com\/discussion\/108880\/recover-a-row-that-was-accidentally-moved-then-deleted","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108880\/recover-a-row-that-was-accidentally-moved-then-deleted","format":"Rich","lastPost":{"discussionID":108880,"commentID":390348,"name":"Re: Recover a Row that was accidentally moved then deleted","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/390348#Comment_390348","dateInserted":"2023-08-12T05:12:42+00:00","insertUserID":165013,"insertUser":{"userID":165013,"name":"GlennJo","title":"Riparian Stewardship Program Manager","url":"https:\/\/community.smartsheet.com\/profile\/GlennJo","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-12T03:46:04+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-12T03:46:02+00:00","dateAnswered":"2023-08-11T23:45:38+00:00","acceptedAnswers":[{"commentID":390342,"body":"