Importing comments from excel into the comments

Hi

I am migration a large data set from excel into smartsheet and this includes the history of all the comments over the years. I have converted the comments to a single row for ease of import. Each row has a unique ID that links to the comment with a one to many relationship.

E.g. Col A = Data and Col B = Comment.

I would like to import all the comments into the comment field with a comment date rather than a column in smartsheet.

Is there a way to do this?

Thanks

Mike

Answers