Formulas: maths and complex conditions
Write calculations and conditions with brackets, using answers, scores and variables by name.
Formulas use names in double curly braces, {{like_this}}, for answers, scores and variables. Type {{ to get suggestions.
| Formula | What it does |
|---|---|
{{BUDGET}} * 12 | A monthly budget turned into a yearly one |
({{R1}} + {{R2}} + {{R3}}) / 3 | The average of three ratings |
{{Leadership}} - {{Culture}} | The gap between two scores |
{{Q1}} = "Yes" and {{revenue}} >= 100000 | A condition joining two checks |
Where you can use formulas
- Set a variable to a formula: in a rule, choose Set, then Formula.
- A condition: click Write a formula instead under If.
- An answer check: switch a check to Write a formula.
- Personalised sections: show a section only when a formula is true.