We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now


Custom Fields/Columns in MS Project 2010 Standard

Medium Priority
Last Modified: 2013-11-15
I have created customized columns (text 1 & text 2) at the task usage view.  
These columns relate to resources, for example, one column indicates a particular location where the resource will be working on a particular task and the other column identifies the role the resource plays for that particular task.  
When I try to add these columns at the resource usage view, two scenarios happen.  The location column is not even listed as the choice.
Role column is available to be added, but is empty even though the information has been added at the task usage view for that column.

Is there any way to get both of these columns to be added at the resource usage view as well, without manually updating these columns or creating brand new columns, so they are visible in both task usage and resource usage views.
Watch Question


Essentially, MS Project has a set of custom fields that are visible in TASK views and a separate set that are visible in RESOURCE views. So the TEXT1 you customized in Task Usage is actually a completely different field than the TEXT1 you see when going to resource usage.

This is because Task information and Resource Information are kept in separate background tables of MS Project. Don't know if you are familiar with relational database design, but each custom field in the task views should be a piece of data about the task and each in the resource views should be about the resource.

There is an explanation here that offers a macro that copies from one text1 to the other but I have not been able to get it working properly. If you are familiar with Visual Basic you might give it a go.


Ah... to get the macro working simple change TEXT2 to whatever your field name is. Make sure it is the same on both task view and resource view. Then if you enter values on one side and run the macro it should move things to the other side. It is still not completely automated as it does not happen real time. You have to trigger the macro to make the copy.
Unlock this solution and get a sample of our free trial.
(No credit card required)


The solution worked.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.


Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.