Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Batch process for moving cell contents to Comments?
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!!
Comments
-
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
-
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.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 61 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives