Can I link a Smartsheet cell to a cell in Excel?
Is there a way to make links from Smartsheet to and Excel file? If so what is the best way to do this?
Best Answer
-
At first glance, I'm not quite entirely sure that's possible. If you had your "excel file" data in a separate smartsheet, you could easily link them.
Which direction are you wanting to link? Smartsheet cell update the corresponding excel file cell? Or have your smartsheet updated when the excel file is updated?
If it's helpful any, I have a current solution where we utilize Data Shuttle that will take the excel file and once attached to the Smartsheet, will update how I have mapped. Perhaps DataShuttle could be of use for you? Note - it is a premium application so if your organization does not have it, I would suggest looking into it. There is a good bit of training available on it as well.
Answers
-
At first glance, I'm not quite entirely sure that's possible. If you had your "excel file" data in a separate smartsheet, you could easily link them.
Which direction are you wanting to link? Smartsheet cell update the corresponding excel file cell? Or have your smartsheet updated when the excel file is updated?
If it's helpful any, I have a current solution where we utilize Data Shuttle that will take the excel file and once attached to the Smartsheet, will update how I have mapped. Perhaps DataShuttle could be of use for you? Note - it is a premium application so if your organization does not have it, I would suggest looking into it. There is a good bit of training available on it as well.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 85 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives