nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

API 2.0 formula

domino_api

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?

Find more posts tagged with

API and Developers

Comments

domino_api

Just to clarify, I want to add values in two other columns.

dAVE Inden

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.

Sign in to join the conversation!

Quick Links

Trending discussions

500 Internal Server Error when accessing WorkApps
Hello- my co-worker is getting the Opps something went wrong error. Also know as a 500 internal server error when accessing workapps. Can you please help?
Reports API: Full CRUD Support Now Available
You can now create, read, update, and delete reports programmatically via the Smartsheet API. Reports are no longer UI-only — they're a first-class API resource, just like sheets. What's new The Reports API now supports the full object lifecycle: Create reports from API calls — no more manual setup in the UI Read report…
New Learning Series: "Mastering Smartsheet API" — Part 1 is live
Hey dev friends, We just kicked off a new hands-on learning series for the Smartsheet API Developer Ecosystem: Mastering Smartsheet API. From your first API call to production integrations and the new MCP Server for AI agents — this series covers the full path. Part 1, "Zero to API: Your First Successful Smartsheet…