-
Sync to Googlesheets via API?
Hey, has anyone successfully created a sync from Smartsheets into GoogleSheets to sync data from Smartsheets into Google Sheets? I am looking for some samples or for someone to say they have done it and point me in the right direction for making that happen. Thanks,
-
SSIS package to read Smartsheet data to export the data into SQL database
I need to bring data from Smart sheet data into sql server using ssis. can anyone suggest the steps.
-
Column Type difference between API and GUI
Hi All, I have a somewhat confusing issue within a sheet where the API is reporting a different column type to the interactive gui. Attempting to force the column shown by the API from TEXT_NUMBER to MULTI_CONTACT as per the GUI through the API results in a success returned, however the subsequent re-query returns…
-
Python API
Greetings I am trying to execute the sample API code on GITHUB, in python for me to read and write sheets. I don't understand the use of the following line of codes. Do I need to replace _file_ ? and what do I replace it with ? _dir = os.path.dirname(os.path.abspath(__file__)) # The API identifies columns by Id, but it's…
-
C# SDK - A strongly-named assembly is required
Edit - I started from scratch rebuilding it, and that solved whatever bug was causing the issue. I still have no idea what was wrong. I'm using Visual studio/C# to make a dll for Office/VBA automation. This was working until the TLS 1.0 deprecation on 3/31. I updated the SDK to to the newest version using the NuGet manager…
-
Usage metrics
Hi Smartsheet community, I am trying to create an app that fetches usage statistics/metrics for a given smartsheet account (like number of sheets or items created, edited, opened, etc), but couldn't find any API which could do the same. Webhooks is one way (not exactly), but that also we can create per sheet (not all the…
-
% allocation and duration aren't linked. Will they ever be?
Hi does anyone know if % allocation and duration will ever be linked? And no, I don't want to create yet another column with a calculation to do it for me. Thank you! Karen
-
Bulk Report Update
Has anyone come across a way to update the criterial for multiple reports at once? We have several reports that all draw from the same set of sheets. Every time we start a new project (and thus create a new sheet), we have to go to each report and attach the new sheet. This is tedious and time consuming. I've even tried to…
-
Integration with SAP
Hi all, Purely out of interest at this stage, but has anybody built any integrations between Smartsheet and SAP, just like there are for Netsuite, Salesforce etc ? If so, which integrations have you built and how did it go? I'd also be interested to hear if this is on the roadmap at all. Thanks! Maarten
-
Can Smartsheets make API calls to external APIs
I'm working on a project at the moment to create and edit smartsheets from an external application, however can Smartsheet do the reverse and retrieve data from external APIs?
