---
title: "List calculations"
method: GET
path: "/sheets/{sheetId}/calculations"
tags: ["sheets"]
---

# List calculations

`GET /sheets/{sheetId}/calculations`

Returns all calculations for a sheet

## Path parameters

- `sheetId` string, required — Sheet ID

## Query parameters

- `versionId` string
- `sinceVersionId` string — Version ID
- `commitId` string — Commit ID
- `sinceCommitId` string — Commit ID
- `filter` 'valid' | 'error' | 'all' | 'none' — Options to filter records
- `filterField` string — Use this to narrow the valid/error filter results to a specific field
- `searchValue` string — Search for the given value, returning matching rows. For exact matches, wrap the value in double quotes ("Bob"). To search for null values, send empty double quotes ("")
- `searchField` string — Use this to narrow the searchValue results to a specific field
- `byField` boolean
- `q` string

## Headers

- `Authorization` string, required
- `X-Disable-Hooks` 'true', required

## Response `200`

Response with status 200

- TypeSheetsListCalculationsResponse
  - `data` TypeSheetsCalculation[], required
    - `id` string, required — Calculation ID
    - `workbookId` string, required — Workbook ID
    - `sheetId` string, required — Sheet ID
    - `fieldKey` string, required — Field key this calculation is performed on
    - `type` 'COUNT_EMPTY' | 'COUNT_NON_EMPTY' | 'PERCENT_EMPTY' | 'PERCENT_NON_EMPTY' | 'COUNT_CHANGED' | 'PERCENT_CHANGED' | 'SUM' | 'AVERAGE' | 'MIN' | 'MAX', required
    - `value` number, double — Result of the calculation

## Other responses

- `404` — Error response with status 404

---

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