How can I link cells from an excel form to a column in smart sheet?

TDobson
TDobson ✭✭
in Add Ons and Integrations

I am using this excel form to quote repair work. I would like to link the cells in the excel form to the columns in the smart sheet.


Field Quote Template 4-5-22 copy.xls


· Share on FacebookShare on Twitter

Answers

  • Khasim
    Khasim ✭✭✭✭✭

    Hi @TDobson

    Are you trying to link Smartsheet and Excel? If yes, then you use the ODBC connector to link/overwrite the Smartsheet fields in Excel.

    If this is the case, I'd be pleased to help you in establishing the connection.


    Thanks & Regards

    Khasim

    SSPM Consultants

    Email ID: [email protected]

    Did I answer to your question or fix the problem? Please help the Smartsheet Community by voting it Insightful/Vote Up/Awesome, or/and Accepted Answer. It will make it easy for others to discover a solution or help in answering!

    · Share on FacebookShare on Twitter
  • TDobson
    TDobson ✭✭

    Thank you for your response. Would data shuttle allow me to make a connection to the excel sheet so that when values are entered on that sheet those values would populate the columns in the smartsheet.

    · Share on FacebookShare on Twitter
  • TDobson
    TDobson ✭✭

    It appears that Data Shuttle will not give me the functionality. I will look into the ODBC Connector solution. Thank you for your assistance.

    · Share on FacebookShare on Twitter

Categories

Help shape the future of Smartsheet.
Share your ideas and feature requests.

 Watch video