-
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.…
-
How I can obtain a month's name from a date?
Hi folks, Has anyone knows how I can obtain a month's name from a date? It's like a FORMAT([Date]; "MMM") that returns something like June. Regards, J. Morais
-
Extract List of Unique Values
Hi Is it possible to use Bridge to extract from a column a list of values, run a JS to extract an array of unique values, and then pass this to another sheet and update another column with this unique list?
-
Bridge Salesforce API - SF Contact Module
We're looking to pass contact information associated with Salesforce opportunity records into Smartsheet. We have the Smartsheet / Salesforce Connector in place, but following the current structure would explode the number of fields necessary to denote all possible roles associated with each project. Is it possible to…