Formulas - Nextedy Documentation

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
──────────────────────
sheet configuration         Formula evaluation
"formulas": {               1. Read formula name from
  "rpn": "function  ─────>     column.formula property
  (info){...}"              2. Execute with info.item
}                              containing row data
                            3. Display return value
                               (shown or hidden column)
                            4. Column is auto read-only;
                               readOnly: false also stores
                               the value in Polarion

Formula columns are automatically read-onlyWhen a column has a formula property, Risksheet sets readOnly to true automatically. Users cannot manually edit calculated values. The formula is re-evaluated whenever source values change, whether or not the column is shown; set readOnly: false if the result must also be stored in Polarion.

Calculated Columns — column-level configuration for formula-driven columns
Cell Decorators — apply conditional styling based on formula results
Configuration Properties Index — full property reference including formulas object
Configure Calculated Columns — step-by-step how-to guide