Product questions?
Sign in and ask it here! The community's got your back.

API & Developers

Connect with other developers from around the world and collaborate on ideas using the Smartsheet API.

Multi Select Field Sync Error Via SalesForce Connector
I have a multi select field in a SmartSheet doc mapped to a multi select field in SalesForce. All values match, however I receive a sync error. It looks like SmartSheet does not separate values with a semicolon (;). Is this a known issue or does someone have a work around?
Close Pending Update Requests when a new update request is sent
I need to send out an automated Update Request weekly. However, I have noticed that whenever someone does not action last week's Update Request and this week's gets sent, Smartsheet now thinks there are two update requests pending. So, even if the person does update using this week's update link, the Update Request icon…
Is there a way to have a Donut Chart Diagram show a negative percentage?
I'm trying to mimic the donut chart above in a dashboard but can't get the chart to show the negative number. When I select the columns the donut chart shows the following. Is there a way that I can mimic the chart above?
Why do Smarsheet webhooks force developers to create webhooks only in a production environment?
In the docs, the following is stated: Smartsheet webhooks do not support callbacks to servers using self-signed certificates. The callback server must be using a signed certificate from a certificate authority. The callbackURL cannot be a private IP address. The callbackURL must use one of the following ports: 443 (default…
GET Pending Update Requests only
Is there a more efficient way to get all Pending Update Requests for a sheet? The only way I can figure to do it is to pull ALL Sent Update requests on a sheet (regardless of status) and then filter the array for a Status of Pending in my other application. However, my sheet has north of 1000 update requests (most of which…
Sourcing drop down list
I saw that people had questions about 'sourcing drop down list' from 2015... why it hasn't been implemented yet? will this feature ever be added ? I found one suggestion to "link another sheet", but it can not be dragged to pass the function along to other cells , instead every time i have to select each cell and and pick…
Linux Python 3.6 script example to download a Smartsheet?
I've been searching for several days for a Python SDK script to download a Smartsheet that I have previously created. I have an existing Smartsheet with 5 columns, and 2690 rows. I only want to download the first column which is a number and assign it to an array. What I've tried so far: EXCEL IMPORT Smartsheet offers a…
Mass Attachments from Sharepoint Online
I am trying to figure out if there is a way to create attachments from Sharepoint URLs in mass. I have thousands of files saved on Sharepoint that have a standardized URL path and naming convention that is derived from values in my Smartsheet table. For example, I have 3 fields: Name State Year Test1 GA 2020 Test2 FL 2020…
Field Rules on Forms
Hello, Will smartsheet look to implement field rules on the forms? For example: Show field: New employee email When field: employee type: New Employee is selected It would be very helpful to show or hide fields on the forms. Thanks Quisha
Can I embed smartsheet's functionality onto my website?
Hello all, I know smartsheet has node.js SDK for its APIs. But, I am looking to embed smartsheet onto my website. Also, looking to convert users action into code. is it currently possible? Is there a proper JS SDK for browser? Many thanks

Trending in API & Developers

"Search Everything" API request always response with 'totalCount' limited to 100
Hello, Is there a limit to the total number of search results to 100? For the example, the GET request to URL: https://api.smartsheet.com/2.0/search/sheets/{sheetId}?query=stuff always response with "totalCount": 100 even though I know there are more than that. Is there a way to increase the search results beyond 100?…
Change Agent with Python SDK is not working
Hi, I'm using smartsheet-python-sdk version 3.0.2 with Python 3.11 and trying to set the Change Agent so I can use it to read when receiving the webhooks but although I pass the change_agent parameter this is not being applied. When i made the request using cURL it works fine. The below is how I set the change_agent:…
SmartSheet API call via Alteryx
Hello, I have recently built an Alteryx model to extract data from various smartsheets that I have access to. While the model does what it needs to do, the API call seems to work only on a random selection smartsheet IDs. As a first step, I am extracting the details of the smartsheets that I am given access to (just the…

API & Developers

Categories

Popular Tags

API & Developers

Discussion List

Categories

Popular Tags