-
API export to excel to include the rowpermalink
trying to include the rowpermalink in my sheet export according to the API doc the ?include=rowpermalink in the URL should do it however it does not show in the row with all the other data from the sheet. any help would be greatly apprecitated. $URL =…
-
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…
