API & Developers

Archives for July 2018

Multiple selection on a drop down list
Hi, I read in another tread that the ability to select multiple items in a dropdown list was in development. Does anyone know if that is available now?
API Bug: GetSheets returns rows with null SheetId
I'm running into an issue where SheetResources.GetSheet and SheetResources.UpdateRows are returning rows with a null value for their SheetId. Has anyone else run into this issue? I'm not passing in any parameters other than the target SheetId. I'd like to determine if I have a configuration issue or if this is a bug in the…
Smartsheet to Outlook Tasks
In my Smartsheet projects, in addition to the usual statuses of "complete", "in progress", etc. I have a status called "Action Item" where I designate items that I personally need to take care of. Is there a way to make these items appear as "tasks" in my Outlook? (reason: I prefer to block off times for my tasks in my…
API Error Messages are (truncated)
This must be a simple setting somewhere, but my searches have not found one. Messages such as: Uncaught Exception: Client error: `PUT https://api.smartsheet.com/2.0/sheets/8176365615769476/rows` resulted in a `400 Bad Request` response: { "errorCode" : 1008, "message" : "Unable to parse request. The following error…
Smartsheet to SharePoint
Can Smartsheet integrate with Microsoft Flow and be triggered by a Smartsheet row update vs a sheet update. I want to flow updates from my Smartsheet by row/item to a SharePoint list by item.
Smartsheet for Outlook only works on default email account.
I installed the Smartsheet for Outlook App and it works fine *BUT* it only shows up on my default email. I am running Outlook 2016 on Windows 10 and I am using Outlook to access 7 emails accounts, both business and personal (a mix of MS Exchange, Pop, IMAP) . I have installed "Smartsheet for Outlook" and it works fine on…
Populate a Sheet from SQL server query (C#)
Hi Everyone, I need some help with a fairly simple task we are trying to accomplish -but i am having some hard time getting it to work - We are reading from a SQL server and some of the result needs to be populated into Smartsheet. As i am using Dataset - and trying to update each value on the variable "ProjectName" into a…
Embedding Smartsheet Calendar to SharePoint Calendar
Hello, I am trying to get a calendar on Smartsheet to sync with a SharePoint calendar. I have realized that there needs to be a flow involved to connect the two. When I try to set up a flow on SharePoint it does not connect on Smartsheet. Thank you!
Smartsheet Dashboards vs Live Data Connector Integrations
Hi everyone, Has anyone used the live data connector to integrate with another platform such as Qlik or any other? I know that SM now has the dashboard view, but I do not think it is as powerful as other BI platforms. From what I see, the SM dashboard is a very high level overview and does not give the level of detail that…
Integrating User Profile into Dashboard
Hi, I want to see my project team on the Dashboard (with the profile picture and designation). Can we add Smartsheet users dynamically to the dashboard? thanks

NEW Smartsheet API Documentation - bookmark the updated link! https://developers.smartsheet.com

Trending in API & Developers

Bridge Get Row Id not showing.
Good Afternoon I am new to Bridge and trying to create my first simple workflow to move rows but, I am having an issue with getting the row id. I have tried following the steps in other threads I found with no luck there is something I must be missing. I have a sheet where form entries are submitted. I setup the Smartsheet…
Share solution? Find and replace text in a Sheet (including inside formulas)
I’m trying to build a solution that can search for a specific text string in a Smartsheet — and replace it with another value — across all cells in the sheet, including inside formulas. I'm trying to find a way to "Replace text including in formulas" since this feature is not available within Smartsheet. I've been told can…
Issues with Excel from using Power Automate
We are trying to use Power Automate to pull in Excel attachments from email and put into One Drive, so we can then utilize Data Shuttle to pull in the data. For some reason it does not allow us to open the document, but it opens fine in the email. We have researched and have not found a fix for this issue. Does anyone have…

API & Developers

Discussion List