-
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
-
Using smartsheets as a CRM
Hi everyone, In Smartsheets, I am trying to create a contact data base with a status trigger from a drop down menu... when "Lead Status" changes from "Lead" to "Opportunity" it triggers a bunch of actions I have set up through Zapier to set up the next steps, files, folders, etc. in Smartsheets and GSuite. Does anyone know…
-
Pop ups
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…
-
How to empty objectValue ?
Hello, I'm using the API to change the predecessors of rows, mostly delete some entries to the predecessors field so I can then safely delete the row that was a predecessor to others. I assume it works for rows to update them with a new objectValue field that contains the same predecessors as before minus the one I want to…
-
Calculate/Compute the duration between two dates in working days
Hello, I'm back for more need in API tricks. Here's my case : because we can't edit the finish date of a task from the API, I need to find a way to make a task end at the date I want. For this, I either have the beginning date of my task, so I just need to find the duration to put in the corresponding field to have my task…
-
Unable to parse response from Update row CURL request on Smartsheet 2.0 API
Using Smartsheet 2.0 APi sto update smartsheets using CURL in my application. The request is Request Header = PUT /2.0/sheets/6988860577081220/rows?allowPartialSuccess=false HTTP/1.1 Authorization: Bearer XXXXXXXXX Host: api.smartsheet.com Content-Type: application/json data to be sent:…
-
automatically export and then delete rows
We use SmartSheets to collect a large amount of data using a form. We reach the Smartsheet size limits almost weekly. Currently we log in each week, export the data to excel, and then delete rows based on a date criterion. I have looked at Zapier. It looks like I can have it email me the data in excel but the free version…
-
Formula through API
Hello, I'd like to make a kinda tricky formula write with the API. I don't know if it is possible but I guess it is. I just have no idea how to properly do it. Could someone land a hand on this one ? Here's the case: I'm going to add rows in the sheet, each of them has two date type fields I'm interested in. I want the…
