How to Set Physical Percentage Complete in Project for the Web
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.

- 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.
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.
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.
Navigate to Project for the Web and open the specific project you want to track.
In the Grid view, click on the 'Add column' option located at the right end of the task list header.
Choose 'Number' from the drop-down list of field types to create a custom numerical input.
Title the new column 'Physical % Complete' or a similar clear identifier.
Click into the new field for each task and manually type the physical completion percentage based on actual work completed.

Switch to Microsoft Project Desktop
Use the desktop application if native EVM and Physical % Complete calculations are essential for your workflow.
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. Download and Install: Download WPS Office from the official website and follow the installation prompts.
- 2. Open WPS Spreadsheet: Launch the application and select Spreadsheet to start organizing your project data.
- 3. Utilize Free Templates: Search the built-in template library for 'Project Management' to instantly generate Gantt charts and progress trackers.

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.




