-
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
-
Activity log of all smartsheet usage under my admin
Is there an API now or some way to find the last time a smartsheet was accessed? I don't want to have to traverse the settings behind each smartsheet and export a report one-by-one. I didn't see any recent threads about some API access to that information. Thank you!!
-
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?
-
Collect information from a changing database
I'm trying to find a way to search for information in a big database, but this database is constantly changing (new sheets imported with the API) The big database are split into 6 imported sheets (250 000 cells approximately on each sheet). This sheet is a list of products. I wanted to do a vlookup on these 6 sheets to…
-
How to empty a sheet with 8000 rows
Hello, We have a big excel file that we need to auto update on smartsheet. For that, I use the node js API and it's working well. I run this each night. At one moment, it can't run because the sheet is full ( max row is reached ) so I need to empty the sheet before sending new data. I need to keep the same ID of sheet, so…
-
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?
-
Google Cloud Scheduler job
I just took a look at Google Cloud Scheduler which appears to be a free Google service that will run scheduled jobs. This might be a good place for people to run API commands who don't have access to a local system. /marc
-
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,…