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.
NOTE: I tried to file this several times a support ticket, but the AI BOT was unable to create a ticket and the OG Support Portal no longer allows the direct creation of tickets. Grrrrrr. ISSUE: It appears that the Update Column API PUT https://api.smartsheet.com/2.0/sheets/{sheetId}/columns/{columnId} fails to work as…
We were using python SDK to access smartsheet API's. Have seen most of the end points getting deprecated and provided new end points. Its providing the request with all params using direct API request in documentation. However no reference provided for using python SDK/other SDK's to access the API. Is Smarthsheet API…
what is the cause of "Unexpected character encountered while parsing value: <. Path '', line 0, position 0." error when using the C# SDK. the full log message is: - 2025-09-18 09:58:54 *** Exception in 'ProcessShares(Entity, EntityName, EntityId, Counter, ssWorkspace)' 2025-09-18 09:58:54 1 'ShareResources.ListShares()'…
