Adding Formulas to Custom Fields
|
Availability: Legacy Business, Legacy Enterprise.; Unavailability: Legacy Free, Legacy Professional.; |
|
Availability: Team, Business, Enterprise, Pinnacle. ; Unavailability: Free; |
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.
Note
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 1 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 2 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, Budget, Actual fees, Actual cost, Planned fees, and Planned cost.
-
Custom fields that have a Number, Currency, Percent, Days, Hours, Date, Formula field type.
You can also include constants like numbers as in this example ([Custom Field name X]-[Custom Field name Y])*2, or in the format of days and hours, for example [Due date]+2d.
Supported mathematical operations include:
-
Addition: +
-
Subtraction: -
-
Multiplication: *
-
Division: /
-
Current date: TODAY()
Note
TODAY() function is based on Coordinated Universal Time (UTC), not a user's time zone.
For complex formulas with more than two fields, you can add parentheses to designate the order of operations.
Note
After you complete the steps A-C 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, Percent, 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 Formula 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-Coding Custom Fields page to learn more.