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.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
Check out the Formula Handbook template!