Welcome!

Comments exporting

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?

Find more posts tagged with

Comments and Conversations

Comments

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!

Sign in to join the conversation!

Quick Links

Trending discussions

Quick Fill to Multiple Cells?
Is there an easy way to quickly drag down the same cell values to 1,000+ cells? Important: I have the sheet filtered, as I only want this to be copied to specific rows. I have over 1,300 rows on the sheet, so I can't just use the column formula functionality. I was hoping I could just double click the bottom right corner…
help building chart for dashboard
Hi everyone, hoping for a little help here, I recently did a survey of 240 employees with 9 yes or no questions. I am hoping to create either a linebar or stacked linebar graph showing the 9 questions in a single chart with the question being on the left axis. When I try to do a report to create this graph, Im unable to…
Access to edit and Admin
I have given someone access as an Admin to allow them to create new sheets and edit existing and they keep being told they do not have access to edit. What could be causing this?