---
title: "Run a given formula."
method: POST
path: "/dataset/{handle}/formula"
tags: ["data"]
---

# Run a given formula.

`POST /dataset/{handle}/formula`

Create a new column based on the given formula input. A blank column can be generated with the formula "" .

## Path parameters

- `handle` string, required

## Request body

- StructsFormulateRequest
  - `afterColumnId` string
  - `columnName` string — column name for output
  - `formula` string — e.g. E * 2
  - `literalFormula` string — e.g. Price * 2

## Response `200`

OK

- StructsFunctionResponse
  - `Message` string
  - `Success` boolean

## Other responses

- `202` — Accepted
- `400` — Bad Request
- `401` — Unauthorized
- `403` — Forbidden
- `500` — Internal Server Error

---

[API](https://skmtc.net/freshdesk/apis/gigasheet-api.md) · [All operations](https://skmtc.net/freshdesk/apis/gigasheet-api/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/freshdesk/gigasheet-api/versions/d1e5cbb24557/schema)