API REFERENCE

formula

Formula string applied to this column. Review formula support and original-coordinate rules.

What does this API do?

Formula string applied to this column. Review formula support and original-coordinate rules.

API for Pro features: Built-in formulas, references, dependency recalculation and calculated columns

Exact input and result types

typescript

formula?: string

Item	Value
Required	Optional
Input type	string

Usage flow

Set this on an individual column object in columnDefs. Pass arrays, objects, and callbacks through JavaScript, and use new arrays or objects when applying changes.

Feature explanations and examples

Formula calculation
Formulas evaluate strings beginning with = and display the result in a cell. For example, =SUM(A1:A3) references the first column in the original column definitions and the first three source rows.