API 2.0 formula

edited 12/09/19 in API & Developers

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.

  • dAVE Inden
    dAVE Inden Employee

    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.