Others

Show Total Resource Group Work in Microsoft Project Columns

Olivia MillerOlivia Miller Nov 13, 2026 868 views

Question details

The user needs to add separate Red and Blue columns in Microsoft Project's Gantt Chart view to display total work for resources assigned to each resource group.

Show Total Resource Group Work in Microsoft Project Columns
Product
Microsoft Project
Device & OS
not provided
Scenario
The user has resources assigned to Red and Blue groups and wants to see the total work for each group as separate columns in the Gantt Chart view.
Observed behavior
The goal is to see separate Red and Blue columns that show total Work for resources assigned to each group in the Gantt Chart view.
Before you start

Open the project in Microsoft Project and confirm that resource groups already exist and are assigned to tasks before creating the custom total work columns.

Solution 1Recommended

Create Red and Blue total work columns using Microsoft Project custom field formulas

Use this method when you need to show total Work per resource group in the Gantt Chart view, not Duration or a grouped summary line.

Microsoft Project does not include built-in Red and Blue group work columns, but you can add custom fields whose formulas evaluate each resource group and return the matching Work value.

Use total Work rather than Duration so the columns reflect the actual effort assigned to each group.

1
Open the Gantt Chart view

In Microsoft Project, open the project and display the Gantt Chart view from the View tab.

2
Open Custom Fields

Go to the Project tab and click Custom Fields.

3
Create the Red group work field

Choose a number or text custom field, rename it to Red Group Work, and enter an IIf expression that checks the resource group field and returns Work when the group is Red, for example: IIf([Resource Group]="Red",[Work],0).

4
Create the Blue group work field

Repeat the process for the Blue group, using an IIf expression that returns Work when the resource group is Blue, for example: IIf([Resource Group]="Blue",[Work],0).

5
Insert the columns in Gantt Chart

In the Gantt Chart table, right-click a column header, select Insert Column, and choose the new Red Group Work and Blue Group Work custom fields.

Create Red and Blue total work columns using Microsoft Project custom field formulas
Use total work instead of duration: The formula should return the Work value, not Duration, so the columns show total resource group effort.
Free Microsoft Office alternative

WPS Office as a Free Alternative for Project and Resource Tracking

WPS Office does not open Microsoft Project .mpp files, but its free, lightweight suite includes a familiar spreadsheet where you can rebuild resource group totals and complete everyday office work with Microsoft Office format compatibility.

  1. 1. Download WPS Office: Click Download WPS Office Free from wps.com and install it on your device.
  2. 2. Open an Excel-compatible workbook: Launch WPS Office, click Menu > Open, and select your .xlsx workbook or project tracking spreadsheet.
  3. 3. Customize resource columns: In WPS Spreadsheet, select the column header area, right-click Insert Column, and add Red and Blue group work columns using formulas.
Provides free spreadsheet tools for task lists, resource groups, and total work columns.Opens and saves .xlsx, .docx, and .pptx files with high Microsoft Office compatibility.Lightweight and easy to use with a familiar ribbon interface.Makes it simple to migrate everyday project tracking from Microsoft Office to a free Office suite.
microsoft office alternative - wps office

Frequently Asked Questions

Can Microsoft Project show total work per resource group natively?

Not as separate Red and Blue columns. The common workaround is to create custom fields with formulas that check the resource group and return the matching Work value.

Should I use Work or Duration in the custom field formula?

Use Work rather than Duration. Work reflects the assigned effort for each resource group, while Duration reflects calendar time.

What formula can I use for the Red group column?

Use an IIf expression that returns Work when the resource group matches the Red group, and returns 0 otherwise, for example: IIf([Resource Group]="Red",[Work],0).

Does WPS Office include Microsoft Project?

No, WPS Office does not include Microsoft Project. It includes Writer, Spreadsheet, Presentation, and PDF tools, and you can use WPS Spreadsheet to track resource groups and total work in a workbook.

Can I open Microsoft Project files in WPS Office?

WPS Office does not open .mpp project files, but you can recreate resource and work tracking in a compatible .xlsx workbook and use WPS Spreadsheet to manage it.