Others

Why Microsoft Project Task Custom Fields Are Unavailable in Resource Views

Chanuka GeekiyanageChanuka Geekiyanage Nov 20, 2026 869 views

Question details

Understand why a task custom field cannot be displayed directly as a field in a Microsoft Project resource view.

Why Microsoft Project Task Custom Fields Are Unavailable in Resource Views
Product
Microsoft Project
Device & OS
not provided
Scenario
A custom field created for tasks is needed alongside resource information.
Observed behavior
The task custom field is unavailable as a resource field because it belongs to a different data type.
Before you start

In Microsoft Project, check whether the custom field was created under the Task or Resource field type. Identify whether you need one value per resource or separate values for each task assignment.

Solution 1Recommended

Identify the Field Type and Choose Where to Copy the Value

Use this approach to understand the data-model limitation and plan a macro if the task value must appear with resource data.

Microsoft Project separates task, resource, assignment, and project data. A task custom field belongs to a task, while a resource field belongs to a resource; the two are not interchangeable.

Assignments connect tasks and resources in a many-to-many relationship. Because one resource can have several tasks with different custom-field values, copying those values into one resource field requires a rule for choosing or combining them.

1
Check the source field

Open Project > Custom Fields and select Task to find the custom field and confirm which task values you need.

2
Review resource assignments

Open View > Resource Usage to see resources and their assigned tasks. Use this view to determine whether the value should be associated with each assignment or summarized for each resource.

3
Choose a destination

In Project > Custom Fields, select Resource and choose an appropriate destination field if you need one value per resource. Define how to handle resources assigned to multiple tasks.

4
Automate the copy if needed

Use Developer > Visual Basic in a desktop edition that supports VBA to create a macro that reads the task field and writes values to suitable resource or assignment fields. If the Developer tab is hidden, enable it through File > Options > Customize Ribbon.

Identify the Field Type and Choose Where to Copy the Value
Copied values do not update automatically: Rerun the macro when source values change, or connect the update logic to a suitable project event and test it for your workflow.
Free Microsoft Office alternative

Track Exported Project Data in WPS Spreadsheets

WPS Office is a free, lightweight alternative with a familiar interface for reviewing and editing Excel-compatible spreadsheets. Export suitable Project data to Excel when available, then open it in WPS Spreadsheets for a straightforward transition. WPS does not change Microsoft Project's field model or replace its scheduling features.

Review exported task and resource data in a spreadsheetOpen and edit Microsoft Excel XLSX filesUse a familiar spreadsheet interfaceWork with a free, lightweight Office alternative
microsoft office alternative - wps office

Frequently Asked Questions

Why can't I add a task custom field as a resource field?

Task and resource fields belong to different data types in Microsoft Project. Check the field's type under Project > Custom Fields; a task field cannot be directly treated as a resource field.

Why is an assignment relevant to this problem?

An assignment links a task to a resource. Open View > Resource Usage to review those links: a resource can have multiple assignments, and each task can have different custom-field values.

Will a macro keep the copied field current automatically?

Not by itself. Rerun the macro after source values change, or connect its update logic to a suitable project event and test the result.

Can I copy several task values into one resource field?

A macro can do so, but you must define a rule for selecting or combining the values. Otherwise, multiple tasks assigned to the same resource may overwrite one another.