-
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…
-
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…
-
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…
-
ODBC connector to Excel - how to share resulting workbook
Dear all: Succesfully created an Excel-based workbook where data are sourced from Smartsheet, by installing the SMartsheet ODBC data connector on a Win10 machine; created and configured a DSN; and configured said DSN with my Smartsheet user credentials and API token from my smartsheet account. Let's call me user A. The…
-
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…
-
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…
-
What does smartsheet.models.duration.Duration().elapsed do ?
Hello, My question is in the title. I've been trying to play with that but it does not seem to have any impact on duration behaviour, whether it is in the duration column or as a lag for a predecessor. Thank you
-
AvgIF(Children)
Is there a way to get an average of selected cells (all the Children of a column) only if they are not blank? I am stuck and trying to automate the functions as much as possible. Thanks a ton in advance!
