Hide comments in a published report?
Is it possible to hide comments in a published report? I see this is an option when publishing a sheet as "Read only - HTML", but this option does not appear to be available when publishing a report. 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 a dashboard removes things like comments -- but the interface 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.)