Comments exporting

Nodrog
Nodrog ✭
edited 12/09/19 in Smartsheet Basics

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? 

Tags:
· Share on FacebookShare on Twitter

Comments

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

    · Share on FacebookShare on Twitter
  • Nodrog
    Nodrog ✭

    Thanks will give it a try!

    · Share on FacebookShare on Twitter

Categories

Help shape the future of Smartsheet.
Share your ideas and feature requests.

 Watch video