-
CORS interruption while fetching Smartsheet API
We want to use simple fetch to GET request the data from our Smartsheet instead to the Smartsheet JS SDK. The code snippet is as follows : This JS file has been linked to a HTML file which is being fired up on the browser using Live Server extension available in VsCode. But upon checking the console on the browser (all…
-
How to divide single request with multiple contacts to individual requests.
Does anyone know how to take a single line, with a single multi-select cell, and have that line parse/delineate/divide in to individual lines, either through a formula or an automation? Scenario: we are receiving schedule block request for team, and multiple people may be on the block request, therefore we have multiple…
-
C# API access to row attachments
Greetings, I have been able to use the Smartsheet C# API to access sheet and cell data without issues. I added an attachment to a row and attempted to get information about it via the API: // Load the entire sheet Sheet sheet = smartsheet.SheetResources.GetSheet(selectedSheetID, null, null, null, null, null, null, null);…
-
Transfer ownership to another user using API.
We have requirement that we need to transfer ownership to another user using API. I didnt get any API for transferring ownership to another user. but i got one RemoveUser API. i tried with the api https://smartsheet.redoc.ly/tag/users#operation/remove-user But i got the below error while using the above api…
-
Get Sheet (ID) by Name using Smartsheet API
I was wondering if there is a way to get the sheet Id of a specific sheet using the name of the sheet. Get sheet accepts the sheet id to get the sheet info, but I would like to get the sheet using the name. In Bridge, you have the option to get sheet by id or name, so I was wondering if there is a way to get it apart from…
-
How to determine the workspace ID & Name and folder name if I only have the sheetID?
Hi, I am using the Smartsheet API for Python. I can determine the workspace names and IDs. I can determine the Sheet name and ID. However, I need to know which workspace (ID & Name) and under which folder of that workspace a specific sheet (per sheetID) resides. How do I do that using python, please? Thank you.
-
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.…
-
Entry date/Payments
I have a sheet that tracks payments made by certain clients. When I add a new client that payment is due in June, the formulas are putting in automatically, payments that "should" have been paid in May. How do I make it so that the sheet won't calculate until the "entry date"?
-
Merged: Not able to access Smartsheet API Doc getting error
This discussion has been merged.
-
Smartsheet sending multiple previously updated records for each "on record updated"
I'm using a 3rd party connector to push data to another system when a Smartsheet record is updated. At the start of the day, if I update 1 record, it triggers one "on record updated" event. For every additional change I make to another record, it will be added to the sent events - so if I update a 2nd record and save, it…