Formulas

Calculate values from other fields: how formulas work, every function, and ready-made formulas to copy.

• Formula basicsWhat a formula field is, how an admin creates and edits one, how to refer to other fields, and where the results can and cannot be used.
• Functions and operatorsEvery operator and helper function you can use in a formula, how each field type reads inside a formula, and what an empty field becomes.
• Common formulasCopy-and-paste formulas for deadlines, budget and cost, progress and status, labels and scores, each with the result type to choose and a worked example.
• Fix formula problemsWhat each formula error message means and how to fix it, plus the surprises that give a wrong answer without an error.