In this blog post article, I’ll show you how to create your own custom columns in Project for the Web. While the platform offers a standard set of columns, you may find that you need additional fields to track unique task information not included in the default set of fields. In this post, I’ll walk you through the process of creating custom fields, adding different types of data, and even how to set up a template for reusing these custom fields across multiple projects.
If you would rather watch a YouTube video on this subject, click here or click the thumbnail below.
Creating a Custom Choice Field
In Project for the Web, many project managers like to create a custom Choice field to provide a list of acceptable values in that field. Using a Choice field will limit the project manager from entering a value that is not available on the list of acceptable values. Complete the following steps to create a custom Choice field:
Step 1: Start by Adding a New Column
- On the right side of your project, click the “+ Add column” virtual column header.
- From the top of the menu that appears, select the “New field” item on the menu. Project for the Web will display the New Field dialog.
Step 2: Choose the Field Type
In the New Field dialog, click the “Type” pick list to see the available field types. As of now, Project for the Web offers the following options:
- Text
- Date
- Number
- Yes/No
- Choice
In this example, I’ll create a Choice field to track the schedule risk of each task.
Step 3: Set Up the Choice Field
- In the New Field dialog, enter a name for your custom field in the “Field name” field. I’ll name my custom field Schedule Risk.
- In the Choices section, add a list of items from which to choose in this field. I’ll add three items named High, Medium, and Low.
- If you need additional choices, simply click the “Add a choice” link and then enter the additional choice items.
- Click the “Create” button to save the custom field. Project for the Web will take a moment to generate the new field, and then it will be ready for you to start entering or selecting data.
Creating a Custom Number Field
In Project for the Web, many project managers also like to create a custom Number field into which the project manager will be required to enter a numeric value. For example, I would like to create a custom Number field in which I can track the Cost Center number for each task. Complete the following steps to create a custom Number field:
Step 1: Create a Number Field
- On the right side of your project, click the “+ Add column” virtual column header.
- From the top of the menu that appears, select the “New field” item on the menu. Project for the Web will display the New Field dialog.
- In the New Field dialog, click the “Type” pick list and select the “Number” item as the field type.
- Enter a name for your custom field in the “Field name” field. I’ll name my custom field Cost Center.
Step 2: Understand Rollup Options for Number Fields
When creating a number field, Project for the Web includes a “Rollup Type” pick list. This is useful for scenarios where you need numbers to aggregate up to their summary tasks. Options include:
- Min
- Max
- Sum
- Average
- No Rollup
Select a value in the “Rollup Type” pick list. If you do not need the values to roll up, leave it set to the “No Rollup” item. In my case, I do not need the values to roll up.
Creating a Custom Text Field
In Project for the Web, many project managers like to create custom Text fields, into which they can enter text information. For example, I want to create a custom Text field which I can use to identify which team is needed for each task.
Step 1: Set Up the Text Field
- On the right side of your project, click the “+ Add column” virtual column header.
- From the top of the menu that appears, select the “New field” item on the menu. Project for the Web will display the New Field dialog.
- In the New Field dialog, click the “Type” pick list and select the “Text” item as the field type.
- Enter a name for your custom field in the “Field name” field. I’ll name my custom field Team Needed.
Important Consideration: Custom Fields Are Project-Specific
One key thing to note is that custom fields you create in Project for the Web are only available within the project where they were created. This means that they aren’t accessible in any other projects.
To work around this limitation, you can create a pseudo-template from a project that includes your custom fields and values. Then, you use this template as the starting point for future projects, knowing that the custom fields you need are already included in the project. Here is how to create a pseud-template:
Step 1: Create a Pseudo-Template
- Open a project that includes the custom fields you want to use in all future projects.
- In the upper-right corner of the project, click the “More actions” button (the … button).
- On the “More actions” menu, select the “Copy plan” item. Project for the Web will create a new project which you can use as a pseudo-template that contains the custom fields you want included in all future projects.
- Click the name of the project and enter a name for the pseudo-template. I might enter the name of my pseudo-template using a name like “New Store Opening Template”.
- Close the project and return to the Project Home page.
Step 2: Mark the Template as a Favorite
To make your pseudo-templates easy to find, mark it as a favorite by completing the following steps:
- Float your mouse pointer over the pseudo-template project on the Project Home page.
- Click the “Mark Favorite” icon (it looks like a star) to mark it as a favorite. This action will pin the template in the Favorites section at the top of the Project Home page.
Now, whenever you start a new project, you can simply copy this pseudo-template to have all your custom fields set up and ready to go.
Conclusion
And that’s it! You now know how to create custom columns in Project for the Web, as well as how to reuse them across different projects using a pseudo-template. Custom fields are powerful tools for managing unique project data and keeping your tasks organized.
If you have questions, please add them in the “Leave a Reply” section below. Or if you watched the video, add your questions or comments there. Please subscribe to my YouTube channel and leave “Likes” if you like the videos.
If you would like to have a formal class on using Microsoft Project, here is a link for my classes.
Hello there, esteemed Microsoft Project enthusiasts! It is with great pleasure that I introduce myself as Dale Howard Microsoft Project MVP, a seasoned veteran in the world of Microsoft Project. With a remarkable track record of being awarded the prestigious Microsoft Project MVP (Most Valuable Professional) title for an incredible 20 years in a row, I am humbled to share that I currently hold the distinguished position of being one of only 11 Project MVPs across the entire globe. To say that this achievement is exciting would be an understatement. It is a testament to my unwavering dedication, passion, and expertise in the Microsoft Project domain.
Why Should You Learn from Dale Howard Microsoft Project MVP?
Throughout my illustrious career, I have relentlessly pursued excellence, striving to be at the forefront of technological advancements and best practices in project management. Being a Microsoft Project MVP has endowed me with a wealth of knowledge and experience that I eagerly share with other users of this remarkable software. It has been my privilege to assist countless individuals and organizations in harnessing the full potential of Microsoft Project to effectively plan, execute, and monitor their projects. Through my extensive involvement in the Microsoft Project community, I have built a strong network of like-minded professionals, and together, we continuously strive to innovate and push the boundaries of project management excellence. As an MVP, I not only possess an in-depth understanding of Microsoft Project but also have access to exclusive resources, early product previews, and direct communication channels with the Microsoft Project development team. This unique advantage allows me to stay ahead of the curve, ensuring that I can provide the most up-to-date and relevant guidance to fellow Microsoft Project lovers.
Whether you are a seasoned project manager seeking to enhance your skills or a novice navigating the intricacies of project planning, I am here to assist you every step of the way. Through my articles, webinars, and training sessions, I aim to empower individuals and organizations to unlock the true potential of Microsoft Project, enabling them to achieve their project goals efficiently and effectively. Join me on this exhilarating journey as we delve into the realm of Microsoft Project, exploring its vast capabilities, uncovering hidden gems, and conquering the challenges that lie ahead. Together, we can transform the way projects are managed, revolutionizing the world of project management, one keystroke at a time. So, buckle up and prepare yourself for an unforgettable adventure in the fascinating universe of Microsoft Project.
Ask Questions on the Forums or Contact Me Directly
If you post a question about any of Microsoft’s PPM tools on the public message boards, look to see who the moderator or person that has answered the questions and you see, it’s frequently me answering your questions. Some people like to golf, I love Microsoft Project helping the community get to understand Microsoft Project much better.
Books I’ve Written on Amazon
I’ve been teaching students at all levels for over 20 years and have taught thousands of users around the world. I’ve written and co-authored 23 books on Microsoft Project, Project Online, and Project Server so if you’re like me and like to read over watching a video, you can Check Out My Books on Amazon.
- Managing Enterprise Projects Using Project Online and Microsoft Project Server
- Ultimate Study Guide for Microsoft Project 2019
- Proactive PPM with Microsoft Project 2016 for Project Online and Project Server
- The Ultimate Application Administrators Guide for Project Online
- What’s New Study Guide: Microsoft Project for Project Managers
- Ultimate Study Guide: Foundations Microsoft Project
- Ultimate Study Guide: Advanced Microsoft Project
- What’s New Microsoft Project 2013
- Managing Projects with Microsoft Project 2013
- Ultimate Study Guide: Foundations Microsoft Project 2010 for Project Managers
- Implementing and Administrating Microsoft Project Server 2010
- Managing Enterprise Projects Using Microsoft Project Server 2010
- Collaborating on Enterprise Projects Using Microsoft Project Server 2010
- Managing Enterprise Projects Using Microsoft Office Project Server 2007
- Administrating an Enterprise PMO Project Server 2003
Check Out My YouTube Channel
For the people that like to watch videos, check out my YouTube channel. If you post a question in the comments, I’ll be happy to answer questions or create a new video to answer your question.
See Other Questions I Answer on the Message Boards
If you’ve got a question about Microsoft Project, Project Online or Project Server, check out some of these community post areas.
Microsoft Tech Community
Reddit Project Online Community
LinkedIn Project and Planner Group
Here’s some other blogs and message boards that I answer questions on:
https://www.mpug.com/author/dale-howard/
https://www.dalehowardmvp.com/microsoft-project-tips-and-tricks/
https://answers.microsoft.com/en-us/msoffice/forum/msoffice_project
https://www.reddit.com/r/MSProject/
https://answers.microsoft.com/en-us/profile/029b4dc7-350c-48f1-8f44-5f01718b3b30
Leave a Reply