Discussions - Smartsheet Community

Browse Member Tips

HOW TO: Duplicate / Copy a Group
Smartsheet Support Documentation does not have a way to duplicate, copy, or export a group in admin.smartsheet.com/manage/groups There is, however, a workaround that doesn't appear to be posted anywhere so I'm sharing it here: Open the group in the group list at admin.smartsheet.com/manage/groups Select "View Group" Select…
Formula to add Months to Date
This is the simplest formula I can find to add Months to Date. This considers sum of months exceeding 12, converting it to January and adding 1 to the year. Where: Term column is the number of months to add, Date is the starting date. =DATE( YEAR([Date]@row) + INT((MONTH([Date]@row) + [Term]@row - 1) / 12),…
Pre-Filled Forms Using URL Queries: Tips and Tricks
Using URL queries to pre—fill forms seems to be catching on a bit more lately. There are a lot of resources out there, but they can be kind of spread out, so I figured I would start a thread that has some of the lessons learned, tips, and tricks that I have discovered along the way. Tip #1 [info callout] The first one that…

See all

Recent Discussions

Some APIs not working?
Some of the APIs inexplicably don't seem to be working. For instance, I can make a request to the Get sheet endpoint fine, but when I try to List columns with the exact same variables I get a 404 Not Found response (see attached screenshots). Have encountered this with several other endpoints (for instance, Attach file or…
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 ?
Getting a 403 Forbidden message when copying a folder endpoint
Hi I am getting a 403 forbidden status when trying to use the endpoint to copy one folder to another. This has worked previously and I can access other endpoints of the API.
Make REST API Calls with an Automation
It would be beneficial to be able to leverage Smartsheet Automations to make REST API calls. This has many potential use cases, but one I could see is adding users to Smartsheet groups when the are added to a 'roster sheet' in Smartsheet. It would allow us to use the full power of Smartsheet's API within easy to use…
Getting Blank Rows While Inserting Data directly using Python
Hi Guys I have created a code which will push the latest ticket from ServiceNow Platform into Smartsheet using the Smartsheet API. I am trying to use the POST method to push the row to Smartsheet but due to some reasons it is not getting inserted even if in the activity log it keeps showing as row inserted. When I tried to…
Give API access to mesh and pivot logs
We have multi-step pipelines to build some dashboards (pivots followed by meshes etc). It would be really useful to us to be able to programmatically extract the run logs for nominated pivots and meshes, so we can alert stakeholders and map process progress towards refresh completion.
Pull FROM Reference Link
Dear Community, i have a question, is there anyway to pull the Form link automatic into a sheet or call it by API? Of course i understand that is i have multiple Forms in One Sheet i have multiple adress Like Sheet 1 Adress 78654654 Form A — 4788 Form B — 47654 Is there any logic in the adress so we can match it and pull?
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…
Is aws.relay.smartsheet.com the set of IP addresses that any Smartsheet connections will come from
Specifically I have a client whose security team have forced IP based allow listing on their Salesforce instance, which has of course broken the Smartsheet→Salesforce connector I setup for them. So, are the IPs returned by the aws.relay.smartsheet.com DNS A record the valid list for connections to Salesforce from…
Get hierarchy/parent of sheets
Hi, I came across a blog mentioning that the Sheets folder feature has been deprecated. As SmartSheet users, we now need to migrate our sheet files and folders into workspaces. Additionally, when calling the API to list sheets, it returns all sheets within the account or profile. So, until it will be migrated to a…
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…
📣 Resource Management API Docs–Improved and on the Developers site! 💪
Hello Resource Management community! The Resource Management API is documented more comprehensively than ever in OpenAPI and available on the Developers site! Here's what's new: New Location: Please update your bookmarks! Find the docs at https://developers.smartsheet.com/api/resource_management. Downloadable OpenAPI…
API Support to Create and Update Sheet Filters
Hi Smartsheet Community and Product Team, Our team relies heavily on Smartsheet for project management and dashboard reporting in our enterprise environment. We recently encountered a challenge where a critical dashboard widget depends on a "Milestones" filter (a shared filter that shows rows where a checkbox column is…
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…
How to bulk create cross sheet references using Python and Smartsheet API
Hello, This post provides a solution for quickly adding cross sheet references to a large number of sheets. The cross sheet reference refers to a single column. Caution The API code can update any sheet where you have permission to create cross sheet references. There is no way to automatically remove or edit cross sheet…
How to access the new end points via SDK
We were using python SDK to access smartsheet API's. Have seen most of the end points getting deprecated and provided new end points. Its providing the request with all params using direct API request in documentation. However no reference provided for using python SDK/other SDK's to access the API. Is Smarthsheet API…
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
Transferring files from Terminated "Provisional Members"
How do you transfer Smartsheet files belonging to Terminated "Provisional Members"? There are not the same options as for PAID Member users.
Load sub children with the new api endpoints
The new api endpoints only returns the top level of a workspace or of a folder: As an example let's say i do that call : https://api.smartsheet.com/2.0/workspaces/1234567890/children?maxItems=1000 It will return only the sheets, reports, folder at the root of the workspace. (exact same behaviour for querying folders…
Automating Seat Management now generally available!
September 3, 2025 System Admins can now automate Provisional Member approvals through IT service management (ITSM) systems like ServiceNow, Atlassian, or Freshservice. The newly available integrations streamline seat management and reduce administrative workload for System Admins at organizations with large numbers of…

Welcome!

It looks like you're new here. Sign in to post and engage.