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

TDobson · 10/03/22

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

Khasim · 10/03/22

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.

TDobson · 10/03/22

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.

TDobson · 10/03/22

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

LilyWANG · 06/18/24

https://community.smartsheet.com/discussion/comment/345719#Comment_345719

@Khasim , would you please provide more details about connecting Excel to SmartSheet?

Khasim · 07/02/24

@LilyWANG Consider using Smartsheet's Data Connector for Excel, which allows you to link Smartsheet and Excel , keeping data in sync.

Another option is using third-party tools like Zapier or Microsoft Power Automate to create automated workflows between Excel and Smartsheet.

TDobson · 07/02/24

Thank you for your help.

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

Answers

Categories