Comments exporting

Nodrog
✭
Hello. When i export a sheet from smartsheet where there is also comments been added, this appears on a separate tab on the csv file which is exported. Is there any way of being able to link these comments to the main tab so that i can view on one sheet with the comments all on the same sheet?
Comments
-
Hi Nodrog,
More of an Excel question than a Smartsheet one.
No way to do this without adding other columns on your main sheet and entering a formula like:
=IFERROR(INDEX(Comments!B:B,MATCH("Row "&ROW(),Comments!A:A,0)),"")
This will pull out the comments only. Of course you can vary the Comments!B:B range to include other columns in the Comments sheet.
-
Thanks will give it a try!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives