Can a report be created to pull all "comments" added to a sheet?
I have a request from one of my project managers to pull a report that will list all of the individual comments added to a sheet. Basically, they would like to be able to review the comments added to the individual line items in one holistic report/view instead of having to click through each comment on their sheet. Is this possible?
Answers
-
If you open the Comments tab, you can click on "All" a the top to see all comments.
-
I am also having a similar challenge, I know the comments are viewable, but I have a 1200 line system impact sheet where we are flying the impacts of a project and owners are commenting next steps for assessment. Is there a way to include the comments in the report itself? (Report criteria; if impact flagged yes- add to report) would like it to include the comments for it as well. I am hoping the answer is not; export into excel (which is where we imported from). Given prelim research tho, it's beginning to look like my only option... but holding out hope for ideas.
-
@Cat Werbeck Creating a row report should pull comments and attachments along with the row data.
-
@Paul Newcome thanks for the quick reply, but I am not even seeing it as an option to select in the available columns. If I export- yes, but not in the smartsheet report builder. :(
-
It isn't in the report builder. Here is a screenshot from one of my active reports that shows where the comment is being pulled from the source sheet alongside the row data.