Smartsheet Workspace to excel using the connector
Before upgrading to the next tier (where the connector exists), I want to make sure what I want to do is possible.
Can the connector pass an entire workspace to Excel, rather than individual files.
There is a workspace that contains many gantt chart files and an easy to view row summary of each chart is wanted such that it updates itself. Each new project spawns a new gantt chart file so individual referencing is still too much work.
I know that this is only possible in Smartsheet using manual referencing of the desired column for each cell so I want to send the data to excel to be modified and viewed.
Does the connector allow this behaviour?
Comments
-
Hello,
The Live Data Connector (ODBC driver) will push data to excel on a cell-by-cell basis.
Since Excel doesn't have Gantt chart functionality, the Gantt portion of a sheet in Smartsheet can't be displayed in Excel—you'll want to use a different application that is compatible with the ODBC driver (such as MS Project).
More on how the Live Data Connector works with Smartsheet is available here: https://www.smartsheet.com/apps/smartsheet-odbc
You might also reach out to our Sales team for any questions on what the Live Data Connector can work with: https://www.smartsheet.com/contact?fts=contact-header-nav
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives