Others

How to Create a Custom Field for Task Contributions in Microsoft Project

Amos Gikunda Oct 21, 2026 868 views

Question details

The user needs a way to manually assign and track different task contributions to the overall project completion percentage.

How to Create a Microsoft Project Custom Field for Task Contributions

Product: Microsoft Project
Device & OS: not provided
Scenario: Tracking custom project progress and manually setting task contribution weightings.
Observed behavior: Microsoft Project lacks a built-in field for manual task contribution weighting, requiring users to rely on custom number and formula fields for rollup calculations.

Before you start

Ensure you have administrator or edit access to the project file and are familiar with customizing fields and formulas in Microsoft Project before making changes.

Solution 1Recommended

Track Task Contributions using Custom Number and Formula Fields

Use a custom Number field combined with a formula to track and roll up task completion percentages to the summary task.

By default, Microsoft Project calculates progress based on task duration. To track manual contribution values, you must create a dedicated custom number field for data entry and a secondary formula field to handle the rollup logic.

Access Custom Fields

Navigate to the 'Project' tab on the ribbon and click on the 'Custom Fields' button in the Properties group.

Set Up the Contribution Field

Select 'Task' at the top of the dialog box, then choose 'Number' from the Type drop-down menu. Select an available field (e.g., Number1) and click 'Rename' to change its name to 'Contribution %'.

Create the Logic Formula

Select another empty Number field (e.g., Number2) and click the 'Formula' button. Enter a conditional formula to check completion, such as: IIf([% Complete]=100, [Number1], 0). Click 'OK' to save.

Configure the Rollup Calculation

While still configuring the Number2 field, locate the 'Calculation for task and group summary rows' section. Select the 'Rollup' option and set the drop-down menu to 'Sum' so it calculates the total contribution for the summary task.

Track Task Contributions using Custom Number and Formula Fields

Insert Custom Columns: Once created, remember to right-click your Gantt chart headers and select 'Insert Column' to add your new 'Contribution %' field to the active view.

Solution 2

Use a Custom Flag to Identify Exceeded Allocations

Prevent tracking errors by setting up a flag field to visually warn you if the assigned percentages exceed the allowed total.

Free Microsoft Office alternative

Track Project Progress Effectively with WPS Spreadsheet

If managing complex custom formulas in Microsoft Project becomes too cumbersome, consider using WPS Spreadsheet. It offers an intuitive, lightweight solution for project tracking, complete with free Gantt chart templates and full compatibility with Microsoft Excel formats.

1. Open WPS Spreadsheet: Launch WPS Office and select 'Spreadsheet' to create a new workbook.
2. Search for Project Templates: Click on 'New' and type 'Project' or 'Gantt' in the template search bar to explore pre-built layouts.
3. Manage Contributions Easily: Select a free template to effortlessly manage task allocations and completion percentages using standard spreadsheet formulas.

Rich library of free project management and Gantt chart templatesSeamless format compatibility with Microsoft Excel (.xlsx) filesLightweight software that runs smoothly on low-end devicesFree to use with a familiar, user-friendly tabbed interface

microsoft office alternative - wps office

Frequently Asked Questions

Why doesn't Microsoft Project calculate task contribution automatically?

Microsoft Project primarily calculates overall project completion based on task duration rather than manual contribution weights. You must configure custom fields and formulas if you want to manually track specific weighting values.

Can I restrict users from entering more than 100% in the custom contribution field?

Native custom fields and formulas can only flag when a value exceeds 100%. To strictly prevent users from entering invalid data, you must write and apply a custom VBA macro in your project file.

How do I display these custom fields in my Gantt Chart view?

Right-click on the header of any existing column in your Gantt Chart view, select 'Insert Column', and type the name of your custom field (e.g., Number1 or Contribution %) to add it to the view.

Why isn't my summary task rolling up the contribution percentages?

Ensure that in the Custom Fields dialog box, under 'Calculation for task and group summary rows', the 'Rollup' option is selected and set to 'Sum'. Otherwise, the summary row will not aggregate the underlying custom field values.

Office Quick Solutions