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.
Hi, Since yesterday (dec 18), many calls to the api are failing or taking way longer than expected (2500seconds to read a sheet). What is the current server status and when should it be back to normal ?
I used UiVision to bulk upload images via a form into smartsheet as an attachment. Now I want to upload each attachment into a cell. Is this possible?
I'm looking to develop a solution for copying forms from one sheet to another, based on matching fields in the forms. I am having difficulty, however in getting forms to appear as an attribute or an associated object to a sheet. What is the correct way to use the API for listing/discovering the forms associated with a…
