-
What IPs to whitelist for the webhook callback?
Hello, When an event happens in smartsheet, we are trying to post data to a webhook URL but do not know what URL to whitelist. We tried "aws.relay.smartsheet.com" but this is not working. Any guidance here?
-
Summary field with formula by API
Hello everyone, I have a function that I run via API that helps me replicate improvements across all the spreadsheets for projects I work on. I tried to insert a new formula field into my spreadsheet using this function and it worked perfectly. However, the field results in a formula error and I need to access all theβ¦
-
Smartsheet IP Addresses for Network Restrictions
Hi! I am using Smartsheet webhooks to stream events of updates on items Along with hmac authorization, I also want to restrict network access so that requests coming from Smartsheet server will be catered, and all other go unauthorized can I get the set of IPs of Smartsheet?
-
Role requirements for API Access?
Is there any role requirements for API access, especially for List users and groups?
-
Unable to Parse JSON for Summary Field Updates
Hi, I'm just attempting to use Smartsheet's API to update the values within the summary fields of a newly created sheet. I got my function for updating the columns to work, but I keep receiving the error below when I try to update the summary fields. ERROR - {'errorCode': 1008, 'message': 'Unable to parse request. Theβ¦
-
Why does a contact list show up as a Text_Number when called by python
I have a column that is Multiuser contact list , when i get it from python it comes back as this Column ID: 717095194388356, Title: Responsible Engineer(s), Type: TEXT_NUMBER, options: []. i have a list of all the contacts i want to write to the options in multiple columns so i only have to manage one list of emails. iβ¦
-
ETQ Reliance Integration
My company uses ETQ Reliance QMS software. It has capability to integrate through API with Office, SAP, Salesforce, etc. Is it possible to integrate with Smartsheets as well?
-
Is it feasible to automatically transfer input from form data with added formatting and information?
Hi, I am attempting to reduce the need for manual data entry. Essentially, I would like a system where a sales colleague can check off a list of processes when they receive an order, lets say A, B, and C. A new sheet is created for production showing they need to complete processes A B C. The problem I am facing is that Iβ¦
-
Bulk toggling of 'Record a Date' automations
I have nice little script to iterate through hundreds of sheets and update contact fields that lack a display_value, so that names consistently show up instead of email addresses. But there are 'record a date' automations tied to those cells that need to be turned off temporarily to avoid triggering them and overwritingβ¦
-
Has anyone been able to successfully upload a .pdf file to a row using VBA?
Hello, I've been able to load a .pdf file to a specific row on my sheet. However, the file isn't converted correctly when using MS Access 16 VBA on Windows. I've tried using bytearray, ADODB.stream, Base64 encoded, and multiple other variations that AI has recommended, but I'm not able to read the uploaded file using anyβ¦