Comments exporting

Comments exporting

edited 12/09/19 in Using Smartsheet

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? 

Tagged:

Comments

  • Chris McKayChris 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.

  • Thanks will give it a try!

Sign In or Register to comment.