Can I importrange data from a Smartsheet into a Google Sheet?
Is it possible to have an importrange in a googlesheet that is pulling live data from a Smartsheet? This is what I am trying to achieve:
We need to implement a consultant request process. Requester fills out form with all necessary information, that is routed for approval from Ppl Ops, Finance, and Dept. Head, and then once approved, that info needs to feed into Legal's already established tracker in google sheets. I would set up an importrange on Legal's spreadsheet that would pull the approved data from Smartsheet (after approval, I can set it up in SS to have that line item move to a different SS so legal does not get the info while it is in the approval process).
Help Article Resources
Check out the Formula Handbook template!