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, smartsheetguru.com
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, smartsheetguru.com
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
Help Article Resources
Categories
Check out the Formula Handbook template!