Comments exporting
Options
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!