Rolling Up Custom Field Data
Regular users can enable custom field data rollup for projects and folders unless their access role restricts it.
Rolling up custom field data is an easy way to populate custom fields of projects or folders. It uses data based on values from tasks that live within the project or folder.
When you enable custom field data rollup:
-
Wrike takes all values of this custom field from the subprojects/subfolders, tasks, and subtasks within the project or folder. It automatically calculates their sum or average and enters the result in the project or folder's custom field.
Notice
Values from subprojects are taken into account only if they were entered manually. If the subproject’s custom field value was also rolled up, it won’t be counted.
-
Wrike calculates the rolled-up value for the project/folder as a sum or average according to the default aggregation set in this custom field’s properties.
-
If you or other users manually entered a value for this custom field in the project/folder previously, it will be cleared and replaced with the rolled-up value.
-
The project/folder’s custom field will not be editable until you disable data rollup.
Note
You can roll up data only for Number, Percent, Currency, and Duration types of custom fields.
-
Navigate to the folder or project.
-
Open its info panel.
-
Hover over the custom field you want to roll up the data for.
-
Click on the Aggregate values from children icon.
After you complete the steps, the rolled-up value will be automatically entered in the custom field of the project or folder.
To disable data rollup for this project or folder, simply click on the Aggregate values from children icon again, and the custom field will become editable.
On Table view, you can enable rollup for multiple folders and projects at the same time:
-
Navigate to the folder, project, or space that contains all the projects and folders you want to enable or disable rollup for.
-
Switch to Table view.
-
Click the caret icon in the column title with the name of the field you’d like to roll up.
-
In the menu that appears, hover over Roll up.
-
Select Enable/Disable for all projects.
-
Click Enable/Disable in the pop-up that appears.
After you complete the steps, values in this field will be immediately rolled up for all folders and projects that are currently on the view. Or you can choose to disable it, and the custom field will become editable.
Tip
Rollup is also available for project dates, time spent, the Effort and Booked effort columns.
To roll up values from subitems to parent tasks, you can create a Formula field based on the system field (select either Time spent or Effort field and save as your formula). After that, put it next to the source field to overview real task values vs summed subitem values next to each other.