Sign in to join the conversation:
Has anyone had any experience of trying to add a formula through the 2.0 API? If so could you please let me know what the JSON syntax should be?
Just to clarify, I want to add values in two other columns.
You can work with formulas via the Smartsheet API. When constructing a cell object you can use the "formula" attribute with a string of the formula you wish to add to the cell.
An example Cell Object would look like this:
{ "columnId": <COUMN_ID>,
"formula": "=SUM([Column1]:[Column1])"
}
This would work when adding a new row or updating an existing row.
More info on Cell Objects is in the API docs here.
I know this is a problem with EU region as well, but wanted to know when regions other than north america will get support for apps like zapier. Everywhere I have read it is always the app developers saying they are waiting on smartsheets. I have tried cloning the connection app on the websites like zapier and maker and…
Hi - my organization has been using Smartsheet for several years and we're looking to automate wherever possible for consistency and efficiency. Whenever a new project starts, the PMO creates a timeline (save as new) from a template that's specific for that project type. The PMO manually updates the default value in a few…
I've a sheets where the columns names are the following (without the quotes) : "Expiration Date " "Expiration Date " So, the first one has a space at the end and the second one hasn't. Previously that was supported by smartsheet API AND the user interface, although it's not possible anymore. What's funny : Most features on…
