How to copy all comments in a row from one sheet into another?

jamiefico

How can I copy all comments in a row from one sheet into another? I ask b/c I have project-based rows, and when the project closes, I move those rows to an overall archive sheet for all projects.

MarceHolzhauzen

Hi @Jamiefico

There is a manual way to achieve the outcome - you can find it at https://help.smartsheet.com/articles/770589-copying-a-row-to-another-sheet#:~:text=Right-click%20the%20highlighted%20selection.%20In%20the%20row%20menu%2C,Select%20Include%20Attachments%20or%20Include%20Comments.%20Select%20OK.

If you make use of an automation, the row and all it's comments will automatically copy across. Take note that making use of the copy function does not keep comments in sync across multiple sheets. It might be worth your while to move the rows instead of copying them, this way the conversation will all stay in one place.

Here's the link to the automation instructions:
https://help.smartsheet.com/articles/2479626-automatically-copy-rows-between-sheets

Toodeloo!

jamiefico

Thank you for the great guidance, I will apply it.