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…
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),…
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…
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…
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…
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…
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?
Last week, Smartsheet announced the deprecation of the API call "GET /templates" with no plan for any replacement mechanism. We have a long-standing integration from our software platform that serves mutual customers of Smartsheet and our product that fundamentally depends on the response to the "GET /templates" API call.…
Hello - I am trying to update my APIs due to the deprecation announced. I am having trouble with the new share API for sharing a workspace. Below is what I have in my HTTP request, and the error I am receiving. I have tried a few things, but I can't get past this error. Share asset { "assetType": "workspace", "assetId":…
We currently connect to smart sheet using Microsoft tools like Power BI and power Automate. Will Smartsheet API Deprecations have any impact on the way we connect to Smartsheet?
It looks like you're new here. Sign in to post and engage.