-
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.…
-
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…
-
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…
-
Loop back to the start of a Bridge Workflow
I am trying to build a help chatbot that our team members can use to quickly find help docs on various topics/processes. For example the chat would look something like this - If you answer yes I want the chatbot to loop back to the very start and clear any history from the previous questions/answers, and if you answer no…
-
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…
-
Enable File Handling in Bridge
Make it possible for Bridge to hand files as variables and results from actions. The example being a SharePoint API call returns a file that will then exist in the reference data of that complete action. This file/reference could then be used in future actions such as another API. My scenario required the use of the…
-
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);…
-
Can Bridge use Smartsheet APIs with HTTP Call Utility Function?
Hi, I'm trying to manage some automated attachments of files to rows in Smartsheet. I've gotten to the point of retrieving the file from its source and am ready to upload it to a Smartsheet row via API. I also have this API request working in Postman. Where I am struggling is when I try to implement this API request in…