Why Microsoft Project Task Custom Fields Are Unavailable in Resource Views
Question details
Understand why a task custom field cannot be displayed directly as a field in a Microsoft Project resource view.

- 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.
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.
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.
Open Project > Custom Fields and select Task to find the custom field and confirm which task values you need.
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.
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.
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.

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.

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.




