> ## Documentation Index
> Fetch the complete documentation index at: https://developers.myhero.so/llms.txt
> Use this file to discover all available pages before exploring further.

# Set formula

> Configure a formula for a formula-type column. The expression uses column names wrapped in curly braces, e.g. " + " or " * - ". The tool resolves column…

`set_formula`

Configure a formula for a formula-type column. The expression uses column names wrapped in curly braces, e.g. "\{Salary} + \{Bonus}" or "\{Price} \* \{Quantity} - \{Discount}". The tool resolves column names to per-row cell IDs and computes initial results. Referenced columns must be number or money type. Supports +, -, \*, / and parentheses.

## Parameters

<ParamField path="tableId" type="string" required />

<ParamField path="formulaColumnName" type="string" required>
  The name of the formula column to configure.
</ParamField>

<ParamField path="expression" type="string" required>
  Math expression using column names in curly braces. E.g. "\{Salary} + \{Bonus}", "\{Price} \* \{Quantity}".
</ParamField>