Smartsheets and Google Sheets

Options

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.

Answers

  • JeremiahHorstick
    JeremiahHorstick ✭✭✭✭✭✭
    Options

    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
    Options

    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
    JeremiahHorstick ✭✭✭✭✭✭
    Options

    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