I am trying to determine if upgrading Smartsheet to the business tier is worth it right now. The main thing deciding this is whether I can connect all of the files from a workspace to Excel Power Query using the Live Data Connector.
I have searched through the smartsheet help and odbc connector setup page yet I am still not sure if the connector can do this.
What I am trying to do overall is scan many gantt chart files into an excel query and customize the data so each file is turned into a horizontal row of data to be displayed.
I have this working with downloaded smartsheets (now excel files) in a local folder but I want to make sure this works before I get the company to upgrade to the next tier.
The Smartsheet Live Data Connector is an ODBC driver that can be used to pull data from a sheet or report in Smartsheet to any client that supports pulling data from an ODBC Driver. There are specific instructions for using the Smartsheet Live Data Connector in Excel and more general information about the Live Data Connector as well.
You might also want to describe the end result you're seeking to a Customer Success Representative at Smartsheet. As the idea of getting each project summarized and then to appear as a single row in a Smartsheet Dashboard or Report is also a capability built into Smartsheet that may meet your needs without having to resort to storing data offline and in multiple places.