-
Connect any MCP-compliant AI tool to your Smartsheet data with the new MCP Server
March 24, 2026 The Smartsheet MCP Server is now generally available — and we're excited to see what you build with it. If you've ever wanted to ask an AI tool a question about your live Smartsheet data and get an intelligent answer back, that's exactly what this enables. The MCP Server is an open integration layer built on…
-
Sunset copy-related query parameters for Create folder and Create workspace API endpoints
March 10, 2026 If you've been using the Create folder or Create workspace API endpoints to copy resources, it's time to switch to the dedicated Copy folder and Copy workspace endpoints. We sunset the copy-related parameters (include, exclude, skipRemap) on the Create endpoints because having separate, purpose-built Copy…
-
New API endpoints make finding asset paths easier
February 16, 2026 Developers, we've heard your feedback! You can now retrieve the complete hierarchical path for any folder, sheet, report, or dashboard with a single API call. No more writing complex code to traverse entire workspaces — these new endpoints give you exactly what you need to display or navigate asset…
-
Smartsheet Automation Sheet Links and Bug Report
I had an automation that would copy rows to a duplicate sheet with test formulas / API connections. I moved this sheet to a new workspace with more limited permissions of other users, and the automation broke. I deleted and attempted to remake this Automation but searching the sheet name in the copy rows section it cannot…
-
Return the full set of properties for every object type in Smartsheet
Before I explain my suggestions, I would first like to give some context on how I use the Smartsheet API. I develop implementations for SQL connectivity interfaces such as JDBC, ODBC, ADO.NET, etc. for various sources (one of those sources being Smartsheet). I use the Smartsheet API to get data for the main resources in…
-
Creating Gantt via API / SDK ?
We're looking to create a Gantt chart by inserting the data and creating the chart via the API (actually via the Java SDK, but either will do). Inserting the data is fine, but cannot seem to get the setDependenciesEnabled (which believe need for the Gantt ) or setGanttEnabled() to work… We think part of this is the order…
-
Smartsheet API List Workspace Children
Hello, I'm trying to use the Smartsheet API to get a list of sheets in a workspace using: https://api.smartsheet.com/2.0/workspaces/{workspaceId}/ However, my workspaces are organized with folders and this only returns the top level folder and nothing else. How can I have this return every child object in the workspace no…
-
Alternative API endpoint for listing workspace templates after Feb 2026 deprecation?
With the announcement of the deprecation of "/workspaces/{workspaceId}" and the deprecation of the template listing endpoint (https://developers.smartsheet.com/api/smartsheet/changelog#template-listing-endpoints) There does not seem to be a way to retrieve a list of templates for a given workspace. Our app relies on these…
-
Controlling record visibility in reports using Smartsheet Groups
This solution allows you to combine the "Current User" filter and Smartsheet Group membership to filter records based on who is a member of a Smartsheet Group. Solution overview Python Create scheduled task to run daily Python script that pulls all Smartsheet groups and group members and saves as CSV on SharePoint site.…
-
Severe inconsistencies with token-based pagination in the ListWorkspaces API endpoint
Hello community, I'm experiencing several issues when using token-based pagination (paginationType=token) with the /workspaces API endpoint in Smartsheet: Using the same API Key (so same user), traditional pagination (page and pageSize) correctly returns the full result set (over 300 workspaces) and allows access to all…
-
Keeping the API token secure on a shared hosting website. Using PHP
I have a website on shared hosting. I know that I should keep api tokens out of public_html folders on said website. I would like to use a <domain>/config/config.php file to hold those api tokens for Smartsheets. This approach is working for another application that I integrate with from this website. However, when I put…
-
Update Columns API Possible Bug - unable to clear all options in a MULTI_PICKLIST column
NOTE: I tried to file this several times a support ticket, but the AI BOT was unable to create a ticket and the OG Support Portal no longer allows the direct creation of tickets. Grrrrrr. ISSUE: It appears that the Update Column API PUT https://api.smartsheet.com/2.0/sheets/{sheetId}/columns/{columnId} fails to work as…
-
Power Automate EU connection
Hi, We just recently moved to the EU domain and I can't find a way to login within the microsoft connectors to update the flows I was suing on the US. Is there currently a solution? Thanks
-
Will and API token for a report give access to the Sheet the Report generated from?
Hi, I have a large Smartsheet, I want to generate a row report that reduces information displayed down to a specific group. For that Row Report, if I were to generate an API token and share it to a third party, will that third part have access to the information on the original 'Grid' sheet, or will it be reduced to what…
-
Smartsheet API Deprecations risk?
Without being an administrator (or even in the IT dept), how do I know if my organization is at risk for the Smartsheet API Deprecations events?
-
How do you get APIs to pull from ALM into a sheet with existing columns and automations?
I'm trying to get APIs to connect some of our project management documentation with our existing customer-facing documentation housed in Application Lifecycle Management. We have been able to get the calls working and pulling the desired data into Smartsheet, but as soon as we add additional columns (contacts, text and…
-
Delete all available time entries in Resource management
Hi Team , I'm looking for a way where I can fetch and delete all available time entries from Resource Management preferable programmatically using python. If not I'd like to know more if there an option to do that in a different way which can help delete all time entries in one simple way.
-
API Integration with Epicor P21
We are currently implementing Epicor P21 as our new ERP system and are considering setting up the API integration with Smartsheet. Is anyone else utilizing the API Integration with Epicor P21? How is it working for you? What has it been most helpful for? Thanks!
-
How do I programmatically update Start Date, End Date, Duration and Allocation %?
Hello everyone, I am working with the python smartsheet SDK, and I am experimenting with a smartsheet connected to Resource Management, which comes with a number of default columns - few of them are Start Date, End Date, Duration and Allocation %. I see in the Python API documentation that these 4 columns are not allowed…
-
(500) Internal Server Error - Power BI
Hi All, I use Smartsheet as a data source often in Power BI. For the last two years I have never had an issue with Smartsheet's API, but today I have been getting a "Web.Contents failed to get contents from <insert smartsheet URL here> (500): Internal Service Error. Is this happening to anyone else? Or is this just a me…
-
API / Integrations between Smartsheet and Maconomy
Has anyone connected Maconomy with Smartsheet to bring information from Maconomy to Smartsheet
-
Are Automations the BEST WAY to clear a sheet before a Bridge Workflow is run?
I've seen various ideas on how to clear a sheet using bridge before beginning a workflow. However, could it be as simple as this?: Add a checkbox column such as "Delete Row" Use Bridge to change all rows to be removed using an "update sheet" in Bridge. Use automation to move rows out when the row is checked instead of a…