Skip to main content

Formula Syntax

Structure of formula functions, the info parameter object, accessing row data via info.item, and return value handling.

Formula Functions

Built-in helper functions including cross-row aggregation with getMasterRowsByColumnValue(), data access patterns, and top panel integration.

Formula Examples

Ready-to-use formula configurations for RPN calculation, risk level classification, title generation, field concatenation, and FMEA/HARA workflows.

​
How Formulas Work

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
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.
KB ArticlesSource Code
  • AppConfig.ts
  • AppConfigHelper.ts
  • risksheet.json
  • CellPreviewFormatter.ts
  • PolarionAppConfigManager.java