-
update request for row (js node)
HI! I use: smartsheet.sheets.getSentUpdateRequest(options) to get a list of all UpdateRequests and their IDs To find out in which row this UpdateRequest I use: smartsheet.sheets.getSentUpdateRequest(options). But there is a problem. I know idRow, how do I remove all UpdateRequest from this row? Or how to easily and quicklyβ¦
-
Is it possible to update a shared with sheet, by the shared with user via the APIs?
I'm updating sheets via the API, I have a sheet that was shared with me, where I have admin level access. Doing a SheetResources.UpdateSheet(sheetObject) returns an unauthorized error on the shared with sheet. Only the sheets that I own seem to be updatable via the API, any sheets that were shared with me, I am notβ¦
-
Bridge: How do I dynamically pass RowID or Object to child workflow?
Hello, Does anyone know how to use Bridge to dynamically collect the RowID from a parent workflow to use in a child workflow? What I'm attempting to do is have a workflow run daily to look at a sheet and collect any rows with a checkmark for "due today". Then I want the workflow to only take specific data and build a JSONβ¦
-
Smartsheet API - Is it possible to copy a folder and in the process save calculations as static?
I am new to Smartsheet API and have successfully used the Postman App to copy and save a folder from one location to another, maintaining: data cellLinks attachments discussions filters forms rules My sheets have cross sheet references and calculations. Ideally, I would like to enhance my API process by essentially copyingβ¦
-
How to use access_token? (api.smartsheet.com/2.0/token)
Node.js How to use access_token? I'm making a request: axios.post('https://api.smartsheet.com/2.0/token')... response: { access_token: 'xxx', token_type: 'bearer', refresh_token: 'xxx', expires_in: 604799 } var smartsheet = client.createClient({ accessToken: 'xxx', logLevel: 'info', }); But the result is always the same:β¦
-
Smartsheet - Microsoft Dynamics Connector - Where do I find the Workflow ID?
Hello dear members, I am running into some troubles with my Smartsheet - Dynamics Connector, getting about 300 error messages per day for whatever reason. The Smartsheet support team is asking me for a Workflow ID of the broken Workflows. Simple question: Where do I find the Workflow ID ? I am not an admin, though cantβ¦
-
Deactivate user API not working.
The deactivate user API is not working as expected. When we hit the API, it gives a 200 success response, but the changes aren't reflected in the admin portal, as in the user is not deactivated. Is this a known issue ? Thanks,
-
Is there any way to get the email faster?
Email Trigger takes 3-5 mins. I need to get it faster. Is there any possible to get faster?. can you please update this issue as soon as possible?
-
How to create a countif formula with OR
I am trying to create a formula across columns with different values in a cell. I have the formula for one value, Preliminary Draft. This works fine. =COUNTIFS({Comments Log Range 1}, [Document Name]@row, {Comments Log Range 2}, "Preliminary Draft", {Comments Log Range 4}, "Open") However, the value in range 2 can also beβ¦
-
Report on User Access when Users are not Registered in MY Smartsheet system
We have an application that has been built on Smartsheet. Several of our clients have the users of our system as Licensed (or unlicensed) Users in THEIR Smartsheet system. Because of this - we cannot add them in our Smartsheet system. We would like to get a report that shows the utilization of OUR system by THEIR users.β¦