Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
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 Builders, You’ve been asking versions of the same question in this community: when do I use Smart Assist, when an automation, when MCP, and when plain API code? 🤔 So we’re starting a new series, the Smartsheet Builders Series: Building with Smartsheet MCP and Agents, and the first post tackles exactly that. 📖 Smart…
Restructuring sheets with tighter dropdowns and clearer naming is key. Why? Because ambiguous column names and free-text status fields that a person reads as fine can produce inconsistent agent behaviour. It’s worth unpacking, because the reason is not that the agent is worse at reading than you are. It is that you bring…
I know I can manually configure a dropdown column in Table View so that its options are linked to a column in another sheet. This is useful because the dropdown values can be maintained in one source/config sheet. However, I have around 100 existing sheets where I need to configure the same linked dropdown setup. I would…
