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

Uploaded Oct 3, 2022349.5 KB

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

Khasim

Oct 3, 2022

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.

@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.

Add Ons and Integrations

Add Ons and Integrations

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

Answers

Quick Links

Categories

Trending Posts

Copy row automation broke after ownership move

User Subscription Model and Dynamic View Permissions

Archiving feature in SCC not moving folder to archive workspace