Custom Fields/Columns in MS Project 2010 Standard

Posted on 2011-04-20
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.
Question by:pmcoordinator
    LVL 15

    Expert Comment


    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.
    LVL 15

    Expert Comment

    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.

    Accepted Solution

    Yes, that worked, even though the macro wasn't exactly correct, it defnitely was very close to what I needed, so I just revised a bit so it would apply to my project plan.

    Thanks for response.

    Author Closing Comment

    The solution worked.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    At the office, we’ve started to get serious about organizing what we’re doing. I mean, it was getting to the point where every time I received a phone call, it began with “I know you’re really busy, but…” My boss was taking tasks away from me left a…
    Article by: x-men
    Where used to see Gantt charts for illustrating project timelines, but what if I wanted to visualize passed timed events? Here's how.
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now