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

# Formulas

> Nextedy RISKSHEET formulas are JavaScript functions that calculate derived values in grid cells.

export const LastReviewed = ({date}) => {
  if (!date) return null;
  const formatted = new Date(`${date}T00:00:00Z`).toLocaleDateString("en-US", {
    year: "numeric",
    month: "long",
    day: "numeric",
    timeZone: "UTC"
  });
  return <p className="mt-10 text-sm text-gray-400 dark:text-zinc-500 not-prose">
      Last reviewed on {formatted}
    </p>;
};

<Columns cols={3}>
  <Card title="Formula Syntax" icon="code" href="/risksheet/reference/formulas/formula-syntax">
    Structure of formula functions, the `info` parameter object, accessing row data via `info.item`, and return value handling.
  </Card>

  <Card title="Formula Functions" icon="file" href="/risksheet/reference/formulas/formula-functions">
    Built-in helper functions including cross-row aggregation with `getMasterRowsByColumnValue()`, data access patterns, and top panel integration.
  </Card>

  <Card title="Formula Examples" icon="file" href="/risksheet/reference/formulas/formula-examples">
    Ready-to-use formula configurations for RPN calculation, risk level classification, title generation, field concatenation, and FMEA/HARA workflows.
  </Card>
</Columns>

## How Formulas Work

```text theme={null}
Formula Execution Flow
──────────────────────
risksheet.json              Grid Rendering
"formulas": {               1. Read formula name from
  "rpn": "function  ─────>     column.formula property
  (info){...}"              2. Execute with info.item
}                              containing row data
                            3. Display return value
                            4. Column is auto read-only
```

<Tip title="Formula columns are automatically read-only">
  When a column has a `formula` property, Risksheet sets `readOnly` to `true` automatically. Users cannot manually edit calculated values. The formula re-executes during grid rendering whenever source values change.
</Tip>

## Related Sections

* [Calculated Columns](/risksheet/reference/columns/calculated-columns) -- column-level configuration for formula-driven columns
* [Cell Decorators](/risksheet/reference/styling/cell-decorators) -- apply conditional styling based on formula results
* [Configuration Properties Index](/risksheet/reference/configuration/properties-index) -- full property reference including `formulas` object
* [Configure Calculated Columns](/risksheet/guides/columns/calculated-columns) -- step-by-step how-to guide

<LastReviewed date="2026-06-24" />