Others

How to Track Two Groups Completing Identical Tasks in Microsoft Project

Natalie TaylorNatalie Taylor Nov 2, 2026 868 views

Question details

The user needs to track the progress of two independent groups completing the exact same list of tasks without duplicating project files.

How to Track Two Groups Completing the Same Tasks in Microsoft Project
Product
Microsoft Project
Device & OS
not provided
Scenario
Managing a project where two distinct teams must complete identical task lists independently.
Observed behavior
Microsoft Project calculates progress at the task level rather than the resource group level, making it impossible to calculate independent percent-complete metrics for two groups on a single task.
Before you start

Determine if you strictly require automated percentage calculations within project management software, or if a flexible side-by-side spreadsheet tracker would better suit your independent group tracking needs.

Solution 1Recommended

Use a Shared Template for Separate Project Files

Creating separate files from a master template allows you to track each group's progress completely independently without building the task list twice.

Because Microsoft Project tracks completion at the task level, placing both groups in the same file limits your ability to see independent percentage completion for the exact same task. Using separate files ensures clean, distinct metrics.

1
Create the master task list

Set up your comprehensive task list, including all milestones and dependencies, in a new Microsoft Project file.

2
Save as a Project Template

Navigate to File > Save As, choose your save location, and select 'Project Template (*.mpt)' from the Save as type dropdown menu.

3
Generate group-specific files

Open the saved template twice to generate two new, identical project files. Save one as 'Project_Group_A' and the other as 'Project_Group_B'.

4
Track progress independently

Open the respective file for each group and update the percent-complete metrics as they finish their tasks.

Use a Shared Template for Separate Project Files
Free Microsoft Office alternative

Track Project Tasks Flexibly with WPS Office

When rigid project management tools limit your ability to track multiple groups side-by-side, switching to a highly flexible spreadsheet tracker is an excellent solution. WPS Spreadsheet offers a free, lightweight, and highly compatible alternative to Microsoft Office, featuring a familiar UI that makes migrating your project tracking completely seamless.

  1. 1. Create a Tracking Sheet: Open WPS Spreadsheet, start a blank workbook, and list your project tasks in the first column.
  2. 2. Add Progress Columns: Create adjacent columns for 'Group A Progress' and 'Group B Progress' to record independent task percentages.
  3. 3. Apply Conditional Formatting: Highlight your progress columns and use Conditional Formatting > Data Bars to create visual progress indicators for both groups.
Highly flexible grid layout perfect for side-by-side independent group progress tracking.Fully compatible with Microsoft Excel (.xlsx, .xls) files for easy exporting and sharing.Free to use with a familiar, easy-to-navigate interface that requires no learning curve.Lightweight installation ensures fast performance even on older devices and operating systems.
QA img-9

Frequently Asked Questions

Can I assign two different resource groups to the exact same task in Microsoft Project?

Yes, you can assign multiple resources or groups to a single task. However, Microsoft Project will calculate and track the task's overall progress collectively, rather than the independent completion percentage of each group.

How do I link two separate group project files to a master project?

You can combine separate files by inserting them as subprojects. Open a new Master Project file, go to the Project tab, click 'Subproject', and select your individual group files to monitor them from a centralized location.

Is there a native way to calculate percent complete per resource in MS Project?

No, Microsoft Project calculates percent complete based on the task as a whole or by duration. To track independent progress per resource on identical work, you must create duplicate tasks and assign one specific group to each.

Why use a spreadsheet instead of project software for duplicate task tracking?

Spreadsheets offer an unrestricted grid structure that allows you to add multiple side-by-side columns to track independent metrics (like Group A vs. Group B completion percentage) for a single task row, bypassing the rigid dependencies and unified task tracking constraints of dedicated project management software.