API and Developers
Discussion List
-
Provide API Access to Upgrade or Downgrade Users under User Subscription Model (USM)
We recently switched over to using USM for license management. This broke our automated scripts that gave users a license. We have a number of non-member employees who we cannot automatically update via the API. I'm told there is no solution for this and we are left manually updating our free users to a licensed member.…
-
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…
-
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 do you standardize addresses in Smartsheet?
Has anyone found a way to validate their address fields in Smartsheet? We are currently using a Smartsheet form to collect business license data and would like to integrate our data to ArcGIS to map the business locations. Currently, we are manually updating all of the citizen-submitted addresses which is a huge time suck.…
-
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.
-
Enable activity log download via API
We would like to automatically obtain & process access data for dashboards and/or sheets, to determine usage. Ideally, we'd like an API endpoint which allows to perform these pulls with the same parameters as currently provided by the manual download.
-
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…
-
Power Automate - Post Attachments to Row/Sheet
Hello everyone! I spent WAY to long looking for this answer so I thought I would share it with the Community in hopes of helping someone else. Problem: Adding attachments to rows/sheet is not possible through the standard SmartSheet Connector Solution: This can only be done by creating a Custom Connector. It CANNOT be done…
-
If deprecating GET /templates, provide another mechanism to get the same data
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.…