Adding Formulas to Custom Fields
You can set automatic calculations for data that you enter in custom and system fields in Wrike using formula fields, a special type of custom field. Use Wrike’s formulas to not only set up automatic calculations of your specific data but also color-code the results and review them at a glance on Table view.
Formula custom fields are similar to other custom fields. In the workspace, they act like other types of custom fields, and the same rules for creating, editing, sharing, and aggregating are applied to them.
Formula fields are visible in Task view and project and folder info panels, but on older accounts created before 25 December 2020, the formula calculation results are only displayed in Table view.
Calculated custom fields and calculations on reports are two different features that need to be set up separately.
Navigate to the folder, project, or space with the fields that contain the data you want to calculate.
Start creating a new custom field.
Select Formula as the field type.
Formula example: ([Custom Field name X]-[Custom Field name Y])*2
Add the names of the fields that need to be calculated:
Click the Formula field to see the full list of available fields that you can add to the calculation formula.
Select a field name from the list or start typing it to find it. Make sure that each field name is in square brackets.
Fields that you can include into the formula:
Default system fields: Duration, Time spent, Created date, Completed date, Effort, Start date, Due date
Custom fields that have a Number, Currency, Percentage, Days, Hours, Date, Formula field type.
You can also include constants like numbers as in the example above.
Supported mathematical operations include:
Current date: TODAY()
For complex formulas with more than two fields, you can add parentheses to designate the order of operations.
After you complete the steps to create a formula custom field, click the Create button and the formula results are immediately visible on Table view. The optional steps described below will allow you to further customize your formulas.
If the result of your formula is numeric – Number, Percentage, or Currency – a special Format field will appear while you’re creating the formula. You can manually change the format of the calculation result on the view in this field.
You can read more about the possible calculation result formats on the Formulas custom fields: Possible formulas and resulting data types page.
You can add color-coding to your formula results in green, amber, and red. Color-coding allows you to define which results are good and which you need to pay attention to. Please refer to the Color-code results in the calculated custom fields page to learn more.