Do’s and Don’ts: Use Resource Labels

dos_and_donts2

A problem frequently posed to me is this: “I don’t have the need for full resource management in Microsoft Project. I have simple projects and manage few people. I don’t need to worry about over-allocation or leveling resources. I don’t track resource cost or work by individual. What I do need is a label on tasks that tells me who is working on them so I can see task assignments at a glance. How can I accomplish that?”

When projects are few, small and simple, this is a reasonable request.

It takes only a little configuration to go from this typical Gantt chart:

Sam_Huffman_resource_labels_figure_1

To this Gantt chart with labels for resources:

Sam_Huffman_resource_labels_figure_2

Notice that resources are identified in the task sheet and the Gantt chart. These are “resource labels.” There are no resources defined in the project displayed above. A resource label is the result of selecting text from a customized text field and associated Lookup table. This is done for each task in a simple list such as those tasks in that first figure. Then they’re grouped, resulting in what’s shown in the second figure, thereby answering the user need for simplicity.


Want more Do’s and Don’ts? Check out Sam’s new book: Microsoft® Project Do’s and Don’ts!


I’ll walk you through the steps to create resource labels. You start by creating the custom field and Lookup table:

1. Click on the “Project” tab and click on the “Custom Fields” button.

2. Configure your custom field and Lookup table as shown in the figure below but using your own resource list:

Sam_Huffman_resource_labels_figure_3

Make sure you “Close” the Lookup table definition and “OK” the “Custom Fields” dialog.

3. Insert the new custom field into the sheet (to the left of the Gantt chart) and pick a resource label for each task that’s available from the new field.

4. Create the Resource Label Group and apply it for visibility by clicking on the “View” tab and choosing “New Group By” in the “Group” dropdown.

5. Configure a custom Group as defined in the figure below:

Sam_Huffman_resource_labels_figure_4

6. Select your new Custom Group from the Group dropdown. It will be listed at the top of the list under “Custom,” as shown here:

Sam_Huffman_resource_labels_figure_5

You can go back to the original look and feel by selecting the “Group” dropdown and choosing “[No Group]” from the built in Groups.

You’re done!

One last thing: Resource Labels are a first step into resource management. It won’t take the place of scheduling and managing resources at the level many of us need in order to report labor cost and effort. It’s a great technique if your needs are simple and you aren’t bombarded with projects.

A version of this article first appeared on Sam Huffman’s blog.

Image courtesy of dann toliver under creative commons 2.0. Image cropped from original source.

Written by Sam Huffman
Sam Huffman first gained insight into Microsoft Project while working as a member of the MS Project development and support team. He has maintained his depth of knowledge of MS Project with each release and is a leading authority in the use and features of MS Project, Project Server and Project Online. Since the early 1990's Sam has honed his instruction skills by delivering training programs to thousands every year. Sam is a frequent content contributor to the Microsoft Project User Group (MPUG) and speaks to groups often about MS Project, Enterprise Project Management and the discipline of Project Management. He was awarded Microsoft Most Valuable Professional from 2010-2017. Check out his blog on MS Project. The softcover version of my newest book Microsoft® Project Do’s and Don’ts is now available for purchase! It is portable, brief and to the point so you can find help when you need it. Through tips, best practices and examples it will help you jumpstart your project!
Share This Post
Have your say!
00
2 Comments
  1. It seems to me that the easier solution is to assign the resources using names only and then group by resource. No need to enter costs, level resources, etc.

  2. The solution proposed by Sam avoids completely the scheduling intricacies that coincide with assigning resources to tasks. The effort involved to implement the solution (a few minutes) is certainly less than the time it takes to figure out how to avoid surprises in the schedule from the scheduling/resource consumption engine, or what to do when a surprise occurs.

Leave a Reply