-
Add row with multiple values in cell using c# sdk
One of columns has 'Contact List' type with checked 'Allow multiple contacts per cell' see example. I tried to add row using smartsheet-csharp-sdk(v2.3). Cell object: new Cell { ColumnId = 111111, Value = "Test@test.com", Strict = false } and I got the next error: { "errorCode": 1235, "message": "Value is not supported for…
-
Generating click.smartsheet email
Hey guys, I am helping a client elevate their Smartsheet setup. Currently, they have an email automation that sends an email to a customer when a certain field in smartsheet has been updated. The email contains a URL starting with "click.smartsheet", the customer clicks on it and updates certain fields in smartsheet. I…
-
Quickbooks & Smartsheet
So. I've been working on this Quickbooks & Smartsheet Integration for a couple of years now for my own internal use. It has many application & the proof of concept exists and we use it. We use it for an approval process (for invoices): The power of Smartsheet i.e. (approvals, communication, notes) makes this a beautiful…
-
"Row Moved" not in Cell History when called by the API?
"When I call "List Cell History" with the API the "Row was moved from another sheet" does not show up. Am I doing something wrong? Why can't I get this cell history?
-
R package for Smartsheet
HI, Does anyone know of an R package for interacting with Smartsheet? Are there folks using R with Smartsheet? I am considering a project using R and I might start building out a package. Thanks Craig info@ngsanalytics.com www.ngsanalytics.com
-
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 =…
-
Change Date column if new row is added after hours
Hello - We have a simple ticket system and if a ticket request from a form comes in after 4:00pm, we don't start the ticket until the next day. Case: Form Entry happens at 2:30pm on 07/27/23. Start Date column should read 07/27/23. Form Entry happens at 4:30pm on 07/27/23. Start Date column should read 07/28/23. So we want…
-
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…
-
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,