Is Picklist always Strict through the API?
I'm trying to update cells via the API and one the cells is in a Dropdown list column. However, when the API tries to add a value to the cell. I'm getting a 1042, "The value for cell in column 7098131356849892, beagle, did not conform to the strict requirements for type PICKLIST." However, I've checked the sheet, the value…
completed task names auto skipping other tasks?
Hi, I am trying to create a project where depending on a certain task completing or not, the project sheet auto skips other listed tasks. This is very simple, but very hard to communicate via words what I am trying to do. For example, lets say I have a project that lists out how to drive a car. Task 1 is does it have gas,…
Dynamically Updating Row Information
I am looking to dynamically update add or delete a row in a sheet based on a checkbox on another sheet. Specifically, we have a sheet that contains all our outstanding balances, and a sheet that contains all our job info. We are looking to have it add a row to our balances sheet when our checkbox isn't checked, and delete…
python api proxy issue
I am new to this. Trying to write a basic python script that uses the smartsheet api. It runs fine from my home desktop, via python for windows. However, when I run it at work on my laptop, I am encountering the '[WinError 10061] No connection could be made because the target machine actively refused it' error. I am…
Automated App Integration Platform
Hi All, We have been using Azuqua to automate our data connection between Smartsheet and our other cloud software platforms. The Smartsheet recommendations such as Zapier are too simplistic for our needs. Since Azuqua was recently purchased, it will no longer exist in a year. Does anyone have recommendations for…
Does SmartSheet support any CURL to get the total row count in a sheet?
I am using curl with REST to access Smartshets in my C# running on WIN CE. My application is supposed to dump some data on smartsheet periodically. Before I write to a sheet, I would like to know the total row count in the sheet so that I don't exceed 5000 rows per sheet. I am looking for an API that would return just row…
using CURL and windows batch file to POST many rows at once
Hi guys, So I’ve been playing on & off with Smartsheet API and have been able to post a row on a sheet succesfully using CURL on Windows via a batch file. Now I need to do the same but for multiple rows from a CSV file. I read that I could do so if I insert an array variable per column within the json part of the CURL…
Future Date Issues
I've noticed that some of the dates entered, if too far in the future will revert to last century. i.e. January 5th, 2050 will work correctly if entered as 01/05/2050 but will think it's January 5th, 1950 if you enter 01/05/50 Also, once you enter the date as 01/05/2050 and it is shortened to 01/05/50, if you edit the date…
Are there plans to allow the API to create forms?
I was wondering if you plan to include the forms object in the API anytime in the future? I have a need to create sheets and forms at the same time. Thanks, David
I used the dashboard as a way to communicate to many within our organization, as many of you do. Recently, this week, it looks like now when anyone clicks on any link within the dashboard a new window opens rather than a new tab within the same window. Also the new Tab is not expandable. I do not have this issue on any…