How to Track Two Groups Completing Identical Tasks in Microsoft Project
Question details
The user needs to track the progress of two independent groups completing the exact same list of tasks without duplicating project files.

- 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.
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.
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.
Set up your comprehensive task list, including all milestones and dependencies, in a new Microsoft Project file.
Navigate to File > Save As, choose your save location, and select 'Project Template (*.mpt)' from the Save as type dropdown menu.
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'.
Open the respective file for each group and update the percent-complete metrics as they finish their tasks.

Duplicate Tasks and Differentiate Groups Using Custom Fields
If you must keep everything in a single project plan, duplicate the task list and use custom fields to assign and filter tasks by group.
Track Duplicate Tasks Using a Spreadsheet
Spreadsheets offer the grid flexibility needed to track duplicate task completion percentages side-by-side without rigid project software constraints.
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. Create a Tracking Sheet: Open WPS Spreadsheet, start a blank workbook, and list your project tasks in the first column.
- 2. Add Progress Columns: Create adjacent columns for 'Group A Progress' and 'Group B Progress' to record independent task percentages.
- 3. Apply Conditional Formatting: Highlight your progress columns and use Conditional Formatting > Data Bars to create visual progress indicators for both groups.

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.




