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.
-
@Paul Newcome Hi Paul, Having a similar issue, how did you create your version in smartsheet?
-
-
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.
-
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.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives