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.
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.
You can roll up data only for Number, Percentage, 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.
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.
The custom field’s default aggregation may be set to None. You need to edit the custom field and change it to Sum or Average.
Or you may not have the right to edit custom fields in the current folder or project due to access role limitations.
Additionally, make sure that the custom field you are trying to roll up is a Number, Percentage, Currency, or Duration type.