Others

How to Set Physical Percentage Complete in Project for the Web

Adam DavisAdam Davis Nov 3, 2026 869 views

Question details

The user needs a way to update physical task progress independently of duration or effort in Project for the Web, which lacks the built-in 'Physical % Complete' field.

How to Set Physical Percentage Complete in Project for the Web
Product
Project for the Web
Device & OS
not provided
Scenario
Tracking project progress based on actual physical completion rather than calculated duration or effort metrics.
Observed behavior
Project for the Web does not natively include the 'Physical % Complete' field found in the desktop version, preventing users from directly inputting this specific metric.
Before you start

Verify your project management requirements to determine if you strictly need native Earned Value Management (EVM) tracking, or if a manual custom field will suffice for your reporting needs.

Solution 1Recommended

Create a Custom Number Field for Physical % Complete

Use Project for the Web's custom fields feature to manually track physical percentage complete.

While Project for the Web lacks a native Physical % Complete field, you can create a custom number field as a workaround to manually input progress percentages independent of the system's duration calculations.

1
Open your project

Navigate to Project for the Web and open the specific project you want to track.

2
Add a new column

In the Grid view, click on the 'Add column' option located at the right end of the task list header.

3
Select field type

Choose 'Number' from the drop-down list of field types to create a custom numerical input.

4
Name the field

Title the new column 'Physical % Complete' or a similar clear identifier.

5
Input progress manually

Click into the new field for each task and manually type the physical completion percentage based on actual work completed.

Create a Custom Number Field for Physical % Complete
Limitation Note: This custom field will not automatically integrate with built-in rollup calculations or native reporting tools like the standard % Complete field does.
Free Microsoft Office alternative

Manage Projects Efficiently with WPS Spreadsheet

If cloud-based project tools lack the custom formulas you need, try WPS Spreadsheet. It offers a powerful, free alternative to Microsoft Office, allowing you to build highly customizable project tracking dashboards with complete control over your metrics.

  1. 1. Download and Install: Download WPS Office from the official website and follow the installation prompts.
  2. 2. Open WPS Spreadsheet: Launch the application and select Spreadsheet to start organizing your project data.
  3. 3. Utilize Free Templates: Search the built-in template library for 'Project Management' to instantly generate Gantt charts and progress trackers.
Fully compatible with Microsoft Excel (.xlsx) files for seamless migrationBuild custom project tracking dashboards and Gantt charts without feature restrictionsUse complex formulas for exact Earned Value Management calculationsLightweight, intuitive UI, and completely free to use
microsoft office alternative - wps office

Frequently Asked Questions

What is the difference between % Complete and Physical % Complete?

% Complete calculates progress based on duration or effort (actual versus baseline). Physical % Complete is a manual entry based on the actual physical work accomplished, regardless of the time spent or resources used.

Will custom formula fields in Project for the Web calculate Physical % Complete automatically?

No. While Project for the Web supports custom fields, Physical % Complete relies on external, real-world assessments of deliverables rather than system-calculated metrics, meaning it must be manually updated.

Can I export my Project for the Web data to track physical progress in Excel?

Yes. You can export your project data to Excel or compatible software like WPS Spreadsheet, where you have the freedom to add custom columns, apply complex formatting, and track Physical % Complete without restrictive software limitations.