SmartSheet connectivity via ODBC

G'day

We are looking at the possibility to migrate our project meeting minutes from Excel to SmartSheet.

The Excel-based minutes have columns that pull data from different sources, being Sage and Dovico via ODBC (extracted data is in another tab within the Excel file), is the same possible in SmartSheet? If so, would anyone be kind enough to point to how this is done?

Thanks guys.

Find more posts tagged with

Construction

Cell linking

Comments

Richard Rymill SBP

There are two choices assuming you are unhappy with Copy and Paste!, which might sound free until you evaluate the consequences of a miss paste!

1#. Smartsheet themselves offer a Data Uploader App details of which are here... https://www.smartsheet.com/datauploader

The cost I believe is @ $10k per annum but you should talk direct to their support team for details.

2#. Our Development team at Smarter Business Processes ( SS partner/ Consultants) have developed a number of API Connectors and automations. One of these is an Excel/CSV connector that maps chosen cells in Excel to chosen cells in your Smartsheet workflows and updates automatically.

This solution has been very well received by many of our clients who use both Excel and Smartsheet and need to keep both in Sync.

If interested there will be a set up fee to show you how to do the mapping, then we just charge a monthly SaaS License fee for support and maintenance @ $50 per month.

More info here ... https://www.smarterbusinessprocesses.com/smarter-apps/

We offer a free initial consultation if interested.

Richardr

Sign in to join the conversation!

Quick Links

Trending discussions

Showing "stacked" data / Statuses of items by swimlane
I have multiple items that each have their own statuses and that roll up to "workstreams" or swimlanes. On the dashboard, I would like to show the progress of the items by swimlane without breaking it out into separate widgets for each. This would ideally be a stacked bar where each bar represented the Items and was broken…
How to Share Single Workspace Folder?
I have a workspace that I created with two subfolders. A user needs to have access to only one of them but when I have that folder selected, I can only share the entire workspace with them. Is there a secret way that I can share the parent folder and ensure that any new files created will be shared with the same people? I…
I have a Pro plan but I cannot create ANY reports
I have a Pro plan but I cannot create ANY reports. The system does not allow me to choose a folder, and consequently a sheet to create a row report and suggests an upgrade to Business or Enterprise. I'm quite new to Smartsheet and feel a bit disappointed with this limitation, or maybe I'm just doing something wrong. Alberto