Fill a Google Sheets or excel template with data in Smartsheet grid
I set up a Smartsheet form for users to input data that populates a Smartsheet grid. I would like to pull selected parts of that data into a separate template where the data is automatically input, like can be done with the Google Doc merge file feature. The end document would preferably be in Google Sheet or excel format.
I did consider inserting a table in a Google Doc and then using the merge file feature but given that many rows and columns of data need to be pulled over this is not an ideal format.
Suggestions on how to do this?
Thanks.
Answers
-
Do you have access to the premium app, Data Shuttle? That is going to be your best option if you have that.
Jonathan Sanders, CSM
"Change is always scary because it is unknown, but facing the unknown is what makes us stronger."
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 140 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives