-
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…
-
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…
-
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
-
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…
-
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…
-
Auto fill information in sheet when a check box is checked in a different sheet
Hello All! I am trying to figure out how to auto fill information into my sheet, when I check a box in a different sheet. I am keeping track of different invoices and sponsorships in the original sheet. When I check a box in the column "Ad" then I want the "Organization", "Event", "Start", and "Due" columns to auto fill in…
-
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:…
-
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…
-
Planning : expected vs reality
Hello ! Does anybody know if how to show on the same line of the Gantt mode, the expected planning and the reality. Here attached is an example of what I need. Thank you for your help !
-
Invalid parentId
Hello, I'm currently building a rather big script using the API and I'm now running into a problem that I can't understand. I'm just trying to add rows under another one, so I specify the parentId (which I've been doing for a really long time and it has always worked until now). Response: { status: 400 Bad Request content:…