Others

How to Count Outline-Level Project Tasks in Microsoft Project

Bushra Parveen Oct 1, 2026 870 views

Question details

The user needs to count specific outline-level tasks representing sub-projects within a master Microsoft Project file and generate a report grouped by project manager and region with completion percentages.

How to Count Outline-Level Tasks in a Master Microsoft Project File

Product: Microsoft Project
Device & OS: not provided
Scenario: Creating a project report that aggregates total sub-projects and calculates percentage complete per project manager across different regions.
Observed behavior: Using a basic custom formula like IIf([Outline Level]=3,1,0) fails to produce the desired aggregated report without correctly structuring the outline hierarchy and grouping settings.

Before you start

Ensure your master project file has a consistent outline hierarchy (e.g., Region > Property > Project) and that the ID fields are correctly sequenced before building your report.

Solution 1Recommended

Verify Task Hierarchy and Create a Grouped Report

Use this method to correctly identify projects at a specific outline level and group them by project manager or region to get accurate counts and completion rates.

In a master project file, identifying sub-projects correctly relies on a strict outline structure. If your regions are level 1, properties are level 2, and projects are level 3, you must isolate level 3 items.

To get an accurate count, you also need to ensure that the summary rows are configured to roll up your custom formulas correctly.

Verify Outline Levels

Open your master project and display the 'Outline Level' and 'ID' columns in your task sheet to visually confirm which level represents your actual projects.

Define Custom Counting Formula

Create a custom Number1 field, right-click the column header, select Custom Fields, and input the formula: IIf([Outline Level]=3,1,0). Under 'Calculation for task and group summary rows', select 'Rollup' and set it to 'Sum'.

Set Up Custom Grouping

Navigate to the View tab, click the Group By dropdown, and select New Group By. Set the primary grouping by 'Region' and the secondary grouping by 'Project Manager'.

Configure Completion Tracking

Decide whether you need to track overall completion or resource effort. If tracking effort, insert the '% Work Complete' column instead of the standard '% Complete' column.

Generate the Visual Report

Go to the Report tab, select New Report, and insert a Table. Add your Project Manager, Region, custom Count field, and % Work Complete fields to build your finalized portfolio report.

Verify Task Hierarchy and Create a Grouped Report

Summary Rollup Settings: If your custom formula returns 0 for grouped totals, double-check that the 'Rollup' setting for summary rows in the Custom Fields dialog is set to 'Sum' rather than 'None'.

Free Microsoft Office alternative

Manage Your Project Data Easily with WPS Office

While Microsoft Project handles complex master files, you can easily track project tasks, group regions, and calculate completion percentages using free project management templates in WPS Spreadsheet. It offers a lightweight, highly compatible alternative for everyday project tracking and reporting.

1. Download and Install WPS Office: Get the free WPS Office suite from the official website and install it on your PC or mobile device.
2. Export Project to Excel format: Save your master project data as an .xlsx file, preserving your hierarchy and manager groupings.
3. Open and Analyze in WPS Spreadsheet: Open the file in WPS Spreadsheet and use Pivot Tables to effortlessly count projects by outline level and average their percentage complete.

Free and lightweight Office suiteHighly compatible with Microsoft Excel (.xlsx) for project trackingRich library of free project management templatesFamiliar user interface for seamless migration

microsoft office alternative - wps office

Frequently Asked Questions

Why does my IIf([Outline Level]=3,1,0) formula return zero in the summary row?

This happens if the summary calculation for the custom field is not properly configured. You need to right-click the custom field, go to Custom Fields, and under 'Calculation for task and group summary rows', change it from 'None' to 'Rollup: Sum'.

What is the difference between % Complete and % Work Complete in MS Project?

% Complete measures the duration of the task that has been completed (e.g., 3 days out of a 10-day task). % Work Complete measures the actual effort or hours logged by assigned resources against the baseline total work.

How do I group tasks by multiple criteria in Microsoft Project?

Go to the View tab, click the 'Group By' dropdown, and select 'More Groups'. Click 'New' to create a custom group. Add your primary criteria (e.g., Region) in the first row, and then add secondary criteria (e.g., Project Manager) in the subsequent rows.

Office Quick Solutions