Smartsheets and Google Sheets

Travis Myers

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.

JeremiahHorstick

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

Travis Myers

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.

JeremiahHorstick

Travis Myers

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