Hello SS Developers! I am both a formula and API-deficient SS user. I believe my question should be directed toward the API/Developer community, as I asked the AI formula developer tool to create a formula for this request and it stated, "Smartsheet formulas cannot be used to automatically organize rows into hierarchy". I…
Hello, I'm trying to set up Smartsheet's webhook listener using Google Apps Script, but having an issue with the verification step. My code looks as follows: function doPost(e) { var challenge = JSON.parse(e.postData.contents).challenge; var response = JSON.stringify({'smartsheetHookResponse':challenge}); return…
In the webhook API documentation the subscope attribute is defined as follows. An object that contains an array of column Ids if you want to limit the subscription to a subscope. Specified when a webhook is created and cannot be changed. But then the example has the following. That is not an array of column ids. That is a…
I thought it might be useful to share a general method I developed to add Functions missing from Smartsheet. This technique makes use of WebHooks & the API. Most important: users can add this to their sheets nearly as easily as they can add formulas. They do NOT need my help as a programmer For example here are a couple…
Hi Guys, I am new to creating webhooks so I apologize if this is something simple. I am using C# to register my webhook with the api. That works as intended. Then, I am calling all of the webhooks for the sheet using `SheetResources.ListSheets(null, null, null)` which also returns the list of webhooks fine. Then I am…
