Import Value from Googlesheet into Smartsheet Cell
Hi
Does anyone know if its possible to read a value from a googlesheet and then import it in a smartsheet - like the importrange function in google?
Thanks
Best Answer
-
Phil,
Not with a formula in vanilla Smartsheet. If you have access to to the Smartsheet DataShuttle and DataMesh apps, then you can use those to do what you want, otherwise you could write your own script to do this over the Smartsheet API.
Darren Mullen, join the Smartsheet Guru Elite
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
Answers
-
Phil,
Not with a formula in vanilla Smartsheet. If you have access to to the Smartsheet DataShuttle and DataMesh apps, then you can use those to do what you want, otherwise you could write your own script to do this over the Smartsheet API.
Darren Mullen, join the Smartsheet Guru Elite
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 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
Check out the Formula Handbook template!