Can a report be created to pull all "comments" added to a sheet?

Jeremy Jones · 06/30/20

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?

Paul Newcome · 06/30/20

If you open the Comments tab, you can click on "All" a the top to see all comments.

Cat Werbeck · 07/13/20

https://community.smartsheet.com/discussion/comment/255253#Comment_255253

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.

Paul Newcome · 07/13/20

@Cat Werbeck Creating a row report should pull comments and attachments along with the row data.

Cat Werbeck · 07/13/20

@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. :(

Paul Newcome · 07/14/20

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.

AdamsR · 08/09/24

@Paul Newcome Hi Paul, Having a similar issue, how did you create your version in smartsheet?

Paul Newcome · 08/09/24

@AdamsR It is a row report.

https://help.smartsheet.com/learning-track/smartsheet-intermediate/reports

.

AdamsR · 08/09/24

Hi Paul, Yes- I know it is a row report; I create them regularly, but the comments on my reports are not pulling over from the project sheet. So, I was wondering what I might be doing wrong.

Paul Newcome · 08/12/24

@AdamsR

My comments (and attachments) have always pulled over in row reports without having to do anything special. If yours are not, you may need to reach out to Support.

Can a report be created to pull all "comments" added to a sheet?

Answers

Categories