-
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?
-
With the recent tableau update to version 2023 the smartsheet WDC is no longer working.
So We recently updated our tableau server to 2023.1.2 version and the smartsheet wdc stopped working , we can still connect to smartsheet but now we are not able to refresh the published datasource. Is anybody else facing this issue? any workaround found for this one? Also according to tableau the smartsheet wdc was based…
-
Triggering Workflows without Accessing the Sheet
I have the following workflow: Sheet 1 (an individual project) statuses are updated Sheet 2 (a summary of that individual project) has calculated fields based off of counting types of statuses in Sheet 1 When Sheet 2 values change the row is copied over to Sheet 3 (a portfolio sheet) Since Sheet 3 is getting a new row each…
-
Reseting a row parentId
Hi, For some needs, i would like to reset the parentId value of a given row. what value should i be using to force the parentId to be reset ? I tried :0; null; "0"; "null" and none of them made any positive result :
-
API Access
Hi, Is there any access level to use API, because via API I can get the value from Smartsheet but I'm unable to update or insert. Thanks, Sandhiya P
-
Workflow and Solution Mapping
Can the automation workflows be exported into a mapping configuration for documentation and recording purposes? Is there a tool or app that anyone uses for this? Part of our IT process is documentation, and having a way to explain in a visual mapping of all the sheets, reports, workflows, and dashboard components would be…
-
How to update picklist column
Hi, Currently I have a few columns which contain individual list items, but when I send an update through the API they appear as a single string Is there a specific way I need to be sending list items so that each item appears individually?
-
Apart from Data Shuttle Is there any other method to upload data from Excel to Smartsheet
Hi Team, I need to upload the data from Excel to Smartsheet, already my Smartsheet is having more than 1000 rows, daily I'm getting Excel report from my team once in a day. So while moving data from excel to Smartsheet, it has to check already that data is present or not. If we present need to update the details of that…
-
How to extract the activity log history of one user in a sheet using Smartsheet API?
Hi, Need help on how to extract the activity log history of one user in a sheet using the API? is this still possible? Can you write me a short python code to start with?
-
Creating Webhook with subscope
Hi, I am trying to create a webhook via payload with the request body like the one below, which is an example from the API document, it failed and returned a HTTP status code 400. { "callbackUrl": "https://www.myApp.com/webhooks", "enabled": true, "events": [ "*.*" ], "name": "Webhook for Sheet Creation", "version": 1,…