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? 

Chris McKay

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.

Nodrog

Thanks will give it a try!