-
Parsing Multi Picklist through API
Hi everyone, I just started working with the SmartSheet API. So far, everything has been straightforward, except one thing; I am trying to submit new rows to a sheet but can't seem to get the value of the Multi Picklist right. If submitted as a string in various formats, the value only displays as one long tag including…
-
Unable to Upload data using R via the API
Hello. I am not a python programmer and attempted to add rows to a desired sheet in Smartsheets using the R "smartsheetr" package. Please see the code snippet below. I am trying to add rows to a sheet from a dataframe based on the sheet id, and subsequent column id's. When I execute the code below I get the following…
-
Event reporting API Enhancements: “to” parameter and Email ID
4/21/2025 Smartsheet has added two key improvements to the Event Reporting API. First, you can now use a “to” parameter to define an end time for your query, making it easier to pull data from a specific timeframe. Second, event responses now include the user’s email address, helping teams identify who performed each…
-
Regression in Create Webhooks API?
Hello in the past 36-ish hours, the response to the Create Webhooks API (POST /2.0/Webhooks) appears to have suffered a regression. Prior to the change, this API (and all other POST and PUT Smartsheet APIs we have been using) would accept the following as the Content-Type header for the HTTP Request: Content-Type:…
-
Return proper error codes
I was updating a row in a sheet by impersonating another user. But the api was sending me an error code 1006 which means 404 not found. The issue was I was impersonating a user who does not have access (shared with) to that sheet. It would be great if the API return the proper error response by saying the user does not…
-
Remove User API enhancements now generally available!
April 30th, 2025 SysAdmins using the Remove User API can now leverage enhanced API functionality to align with the updated Smartsheet governance framework. These updates ensure that removal of users adheres to plan-level security controls, reducing administrative complexity and improving compliance. Removing users from the…
-
Bridge: Update Columns--With Colors?
I'm curious if there is any way to associate colors to the values using the Bridge "Update Column" element. The first column in this image is created manually. The second was created using Bridge. It's not in the API documentation ..and is clearly not in the element: Any ideas?
-
Problems using Python API and Cell History - note returning all user input.
I have been using the cell history to try and grab user input. The Input comes from users typing or selecting from a drop down. The data shows fine in Smartsheets. Dates are auto added but text e.g. "11k Production process complete" is user input when using the report/sheet in Smartsheets. But then when I use this code to…
-
API to modify FORM "Label"
I have to update 250 form labels on a single form. Is there ANY way to do this automatically? I am dreading doing this manually :) There doesn't appear to be any API functionality for forms according to the documentation. Am I just overlooking something or is this not possible? Thanks!