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.
When you work with data in a spreadsheet or an AI client, what usually happens before it ends up in Smartsheet? Pick the closest one, and tell us how it really goes if it’s messier than the choices. It usually is. I copy and paste it over by hand I export a file and import it I clean it up in a spreadsheet first, then move…
At ENGAGE 2026, five customers showed what they’ve actually built with AI on top of Smartsheet. No roadmap slides, just working setups. Here’s the short version: Lilly Kinsale: One live changeover view, built with Claude. It saves roughly 30-35 minutes per core team member every day. Swampfox: AI proposes RAID log updates,…
I’m looking to use Linked Dropdown Columns within a CC blueprint template My setup is that each provisioned project gets its own workspace containing: Project Plan Team Roster I want a dropdown column in the Project Plan to be linked to specific column in that same project's Team Roster. For example: Project A Project Plan…
