API & Developers

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

Persistent permalinks
I have an issue where my permalinks become useless after midnight. I create a bunch of permalinks to the rows in my main sheet. At midnight I move all these rows to an "Archive" sheet. Is there a way for the permalinks to reference the row that has been moved? Anyone else have this need? I had thought about renaming the…
Quotes within a formula for API PUT/POST
How is the data supposed to be formatted when a formula has quotes within it such as =IF(X=1,"One,"") ? I am getting just slashes in place of the quotes when I export a formula using the API, but when I use the same syntax to add/update a column with a formula it doesn't parse correctly. I tried /" and double-quotes.…
Issue with Syncing Smartsheets to Outlook
How do I format the time columns/add proper formulas to get the calendar to sync to outlook with the times included? Right now showing as all day event (see right calendar)
I am trying to update an AutomationRule Object and getting an error:
Exception thrown: 'Smartsheet.Api.InvalidRequestException' in smartsheet-csharp-sdk.dll An exception of type 'Smartsheet.Api.InvalidRequestException' occurred in smartsheet-csharp-sdk.dll but was not handled in user code Required object attribute(s) are missing from your request: action.includedColumnIds. in C# the Action…
SmartSheetAPI PUT
Hello, I want to use the Smartsheet API to update the content of a cell. I have set the API key in the header and tried the following using Postman: PUT Request URL: https://api.smartsheet.com/2.0/sheets/{sheetId}/rows/{rowId}/cells/{columnId} Request Body (JSON): { "value": "test", "displayValue": "test" } However, I'm…
Python SDK API to add rows with Multi Columns to Smartsheet
I have a script that reads columns from my source Smartsheet (SS) and gets the values from the columns in the SS and stores them in variables. This code works. Where I am getting stuck is assigning the variables (2 or more columns) to a new row and then adding the row to the destination SS. For example: Source SS, reads…
Triggering Workflows without Accessing the Sheet
I have the following workflow: Sheet 1 (an individual project) statuses are updated Sheet 2 (a summary of that individual project) has calculated fields based off of counting types of statuses in Sheet 1 When Sheet 2 values change the row is copied over to Sheet 3 (a portfolio sheet) Since Sheet 3 is getting a new row each…
Reseting a row parentId
Hi, For some needs, i would like to reset the parentId value of a given row. what value should i be using to force the parentId to be reset ? I tried :0; null; "0"; "null" and none of them made any positive result :
API Access
Hi, Is there any access level to use API, because via API I can get the value from Smartsheet but I'm unable to update or insert. Thanks, Sandhiya P
Activity log of all smartsheet usage under my admin
Is there an API now or some way to find the last time a smartsheet was accessed? I don't want to have to traverse the settings behind each smartsheet and export a report one-by-one. I didn't see any recent threads about some API access to that information. Thank you!!

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

Export Data Shuttle, Data Mesh, Dynamic Views and Pivots Created
I had a question is it possible to export the data shuttles, mesh , dynamic views and pivots which we have created or the once which are shared to us. If not it would be great if someone brings an endpoint which wud connect it directly so as to pull the data through code
Is there a list of endpoints for which offset-based pagination is being deprecated?
Based on info available in the changelog (specifically https://developers.smartsheet.com/api/smartsheet/changelog#2025-08-04) ) for some endpoints offset-based pagination is being replaced with token-based pagination. Is there a list of endpoints that will be impacted by this change? I am trying to stay ahead of this and…
Move attachments between sheets
Is there any way to move attachments between sheets without the clunky "Move a Row" or "Copy a Row" automation?

API & Developers

Discussion List

Categories

Popular Tags