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.
We are working on adding testing and change management to our Smartsheet instance. What are best practices for managing changes, and having a Dev to Test to Prod style workflow? How are others managing test data and automations that are not in production yet? We are working to add additional functions to our projects,…
We are currently using the Smartsheet API to export and send a sheet as a PDF via email as part of an automated workflow. While generating the PDF, we are able to specify the paper size (for example, A4 or A3). However, we are facing limitations with the following formatting controls: Orientation We are unable to…
Is there any way to move attachments between sheets without the clunky "Move a Row" or "Copy a Row" automation?
