Smartsheets and Google Sheets
Is it possible to link data across the two? I would like to try and reference roughly 3-4 Smartsheet's sheets in Google Sheets. The main reason begin, I am just more proficient in Sheets. Some of the formulas and interactions throw me off in Smartsheets.
Answers
-
Hi Travis,
What do you have in mind?
Bi-directional syncing of a sheet and a Tab on a G Sheet?
Pushing data from a Gsheet to a Smartsheet?
Pushing from a Smartsheet to A Gsheet?
It's something I've been considering working on putting together.
-Jeremiah
-
Ideally it would go both ways. Link data in Smartsheets to feed formulas and such in G Sheets, then send that data back to Smartsheets.
-
This would be tricky because edits in Smartsheet would overwrite your formulas in G sheet & vice-versa.
We could configure a Smartsheet to a G Sheet, A GSheet to a Smartsheet and you could put all your formulas in the middle on either side.
-Jeremiah
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives