API & Developers

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

Order of columns and Row-Cells in response to API Get Sheet request
Hello. In general, I understand that Smartsheet has made it clear that no order of properties or even any order of array entities may be assumed or inferred to any response to any API request. And fair enough. My question is about the response to a single invocation of the API GET SHEET - GET…
Gannt task bar % complete visual wipes out formula and forces static text
I have made a column with % complete based on todays date (using a formula) and it works great. I want to use this dynamic information to display the % complete on the Gannt task bars, but when I activate that setting, the formula gets wiped out (and forced to static text format). I can figure out a work around, but I…
Some attributed of "Sheet" object is not documented but is present in API response?
I noticed that some of the fields/attributes related to "Get Sheet" API has attributes like: which are not documented in the API doc https://smartsheet.redoc.ly/#section/Sheet-Object Could you please help in knowing what exactly is the reason to this? Are these to be considered?
SOLVED API - Finding a user using the email address not the {userId}
Good day, SOLVED! users?email= I have read the API documentation and see that you can query users using the identity {userId}. This of course assumes that you know what the {userId} for a particular user is which is rarely the case as this is generated by SmartSheet and not by the corporation using SmartSheet. The…
How do I generate a text value output based on multiple inputs
Is there a formula that will let me create an output based on selected input of text (not sum of numbers) So i am trying to create a specific output eg if I select the components of an item based on multiple options it gives me the closest output let’s say I select sand, cement, water and it gives an output of concrete.
How to avoid webhook triggering from cell format updates???
I'm using make.com to do some automations when certain columns in a row are updated. Works great until someone re-aligns the columns and updates 1500 cells at once, sending my webhook 1500 requests. I can filter them out by detecting the actual data cell history, but it still uses 3000 operations for no reason and ties up…
Form Customization
I was hoping there is a way to tap into the HTML of the forms to customize them a little more. I'm specifically unimpressed with the spacing options. The form looks as though it's made for mobile devices only. Also, is it possible to group questions? Ie all relevant questions enclosed in a box, same background color, etc.…
Smartsheet API in Python: Inaccessible 429 Response
I am trying to understand / plan for the rate limits, particularly for the get_cell_history method in the python api. When I run the code below, I see the following response printed to my console: {"response": {"statusCode": 429, "reason": "Too Many Requests", "content": {"errorCode": 4003, "message": "Rate limit…
Use API to detect change on ANY sheet?
I know you can use the API to poll for changes on a single sheet or a webhook to send changes whenever an individual sheet is changed. However, is there way to monitor an entire workspace (or the entire account I guess) for any changes that are made to any sheet?
I am unable to create a Developer Smartsheet Account using developer registration portal.
I am unable to create a new developer smartsheet account using the developer registration portal https://developers.smartsheet.com/register/ It throws an error. I have tried multiple times from different browsers or systems. Please help me out here. Thanks in advance.

Popular Tags

Upcoming Events

Brandfolder Collaborator User Guide
Get ready to seamlessly upload and organize content within your Brandfolder! This on-demand session is designed to help you become a confident contributor and collaborator, ensuring your team has the right assets at the right time. What You’ll Learn: Maximize Features in the Asset Modal: Learn to navigate the asset modal,…
Brandfolder Admin User Training
Managing digital assets doesn’t have to be complicated. Join us for this two-part, on-demand webinar series designed to give Brandfolder administrators the confidence and skills to create smooth, efficient workflows. Whether you’re just getting started or ready to optimize your setup, these sessions will help you unlock…
Smartsheet Customer Success Onboarding (Japan)
Smartsheet カスタマーサクセスオンボーディングは、Smartsheet についての基本を学びたい方向けに毎週開催しているインストラクター主導のトレーニングコースです。ウェビナーは、始めるための基本、共同作業、およびさまざまな方法での作業の視覚化の基本など、Smartsheet のご利用を開始するために必要なすべてを網羅しています。

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

Trending in API & Developers

List folder children
I am attempting to use the Python example for Listing Folder Children from the API Reference Docs. No matter what I do I get the following error message: {'errorCode': 1006, 'message': 'Not Found', 'refId': 'qgsta7'} =======CODE======= import requests import os from dotenv import load_dotenv from dotenv import…
I'm embarrassed to ask: How do you write an API
I have a report that beautifully aggregates data from 70+ sheets. I need one column from that report to populate a helper sheet that I have: Source Sheets > Report > Helper Sheet As the report grows with data, I want the helper sheet to grow with it without manual intervention. Ergo, the API question. Here's what I know…
Server Status ?
Hi, Since yesterday (dec 18), many calls to the api are failing or taking way longer than expected (2500seconds to read a sheet). What is the current server status and when should it be back to normal ?

API & Developers

Discussion List

Categories

Popular Tags