Importing comments from excel into the comments

Mike Feighan

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

Andrée Starå

Hi Mike,

I worked with a client recently with a similar need. We ended up adding a new column instead.

It’s probably possible to either use the third-party service, Zapier, or the Smartsheet API to have them added to the comment section instead.

https://zapier.com/apps/smartsheet/integrations

https://developers.smartsheet.com/

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Mike Feighan

Hi Andrée,

I looked at that and it too technical for me. I just need a simple solution to import the comments using Smartsheet not another utility. I think you guys need to improve your import capabilities to import directly into the comments tabe. It can't be that difficult :).

Also, is it possibe to change the user name (created/modified) from an email to a name? I see this was raised in 2016 and not sure if solition was ecer built?

Thanks

Mike

Andrée Starå

Happy to help!

Unfortunately, t's not possible at the moment to change to anything else for the created/modified system columns, but it's an excellent idea!

Please let the Smartsheet Team know that you would like better import options and to be able to change the created/modified columns.

Please submit an Enhancement Request when you have a moment

✅Remember! Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!