Batch process for moving cell contents to Comments?

Spencer Marlow

Hi community

 

We just took a large Excel project sheet into SS. In the old, sheet users were just adding freeform Notes to a column called "Notes"

 

I would simply like to migrate the content of each cell in the "Notes" column, to the Comments field in the new SS ... however with 800 rows to deal with that's a lot of cut-and-paste !!!!

 

Is there any way of automating this process? Would be good to get confirmation even if the answer is "sorry dude no way"

 

Thanks!!

Shaine Greenwood

Hi Spencer,

 

Although there isn't a way to batch copy and paste in the Smartsheet interface into a comment, if you have development resources available, you might consider using the API to accomplish this. The API does require that you have development resources available. 

 

Full documentation on the API is available here: http://smartsheet-platform.github.io/api-docs/?javascript#overview

Spencer Marlow

Got it, thanks Shaine - this is not an issue that would justfiy development work but good to know I was not overlooking anything in the packaged functionality. Appreciated.