What it means
Formula settings shape the spreadsheet layer, especially whether users get a visible formula bar and how references behave when rows or columns move.
Interaction guide
Formula data grid documentation
Formula settings shape the spreadsheet layer. They control whether the formula bar is available and how references behave when rows or columns move.
When to use it
Use it on spreadsheet-like planning and modeling screens where formulas are part of the user workflow. Skip it on simple read-only reports where formulas exist behind the scenes but users never need to inspect or edit them directly.
Implementation notes
Keyed references are usually safer when the table shape changes because they stay tied to field meaning instead of physical position. Keep formula UX visible only where users truly act like spreadsheet users; otherwise the extra controls feel heavy.
Relevant API
Start with formula.enableFormulaBar, formula.formulaReferenceMode. Open the live API reference for types and defaults.