API 2.0 formula

domino_api

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?

domino_api

Just to clarify, I want to add values in two other columns.

dAVE Inden

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.