Skip to main content
The World's Best Known Brand for Microsoft Project and Project Server Expertise

Project Server Experts Community Site

Search
Project Server Experts Community Site
Project Server Help Blog
MSProject Experts
Training Schedule
Contact Us
  
Project Server Experts Community Site > Project Server FAQ KnowledgeBase > changetimesheet  


How do I add or remove columns on the Project Web Access timesheet?



Microsoft Project Server Frequently Asked Questions (FAQs): Overview



Microsoft Project Server Frequently Asked Questions (FAQs): Details

Resolution for Project Server 2002

You can add additional columns to your team members' timesheets, however, Project Server 2002 does not allow you to remove or reorder any of the default fields in the timesheet. To add fields for a specific project, complete the following steps:

1.  Open Microsoft Project 2002 and log into Project Server.

2.  Open the first project in which you will publish additional columns (fields).

3.  Click Tools > Customize > Published Fields.

4.  In the dialog, select the additional columns from the Available Fields list and copy them to the list on the right.

5.  Click the OK button.

6.  Click Collaborate > Publish > Republish Assignments and then click OK.

7.  Repeat this process for each project in which you want to publish additional fields.

Warning: DO NOT skip step #6 above, as this step will actually "push" the additional columns onto the far right end of the task sheet portion of each team member's timesheet.

Tip: After you publish the additional fields to each user's timesheet in Project Web Access, the new fields will appear at the far right end of the columns in the task list on the left side of the timesheet. Users can move the fields anywhere in the table by dragging and dropping the column headers for each additional field.

Resolution for Project Server 2003

To additional columns to your team members' timesheets, the project managers and the Project Server administrator must work together. The Project Server administrator must first complete the following steps:

1.  Log into Project Web Access with administrator permissions.

2.  Click Admin > Manage views.

3.  Select the Timesheet view and click the Modify View button.

4.  Add the new columns to the list on the right and position them in the correct order.

5.  Click the Save Changes button.

Tip: To remove columns from each user's timesheet, the Project Server administrator must perform the same set of steps above, but must remove fields from the list on the right in step #4.

Each project manager must then complete the following steps:

1.  Open Microsoft Project 2003 and log into Project Server.

2.  Open the first project in which you will publish additional columns (fields).

3.  Click Tools > Customize > Published Fields.

4.  In the dialog, select the additional columns from the Available Fields list and copy them to the list on the right.

5.  Click the OK button.

6.  Click Collaborate > Publish > Republish Assignments and then click the OK button.

7.  Repeat this process for each project in which you want to publish additional fields.

Warning: You must perform step #6 above, as this step will actually "push" the additional columns onto the far right end of the task sheet portion of each team member's timesheet.

Resolution for Project Server 2007

Project Server 2007 offers two different pages for reporting time and task progress, which are the My Timesheet page (used for reporting all types of time) and the My Tasks page (used only for reporting task progress). Because of this, the Project Server administrator may need to complete two different sets of steps to add a column to either page. To add a column to the My Timesheet page, the Project Server administrator must complete the following steps:

1.  Log into Project Web Access with administrator permissions.

2.  Click Server Settings > Manage Views.

3.  In the Timesheet section, click the My Timesheet view to open it for editing.

4.  Select one or more fields in the Available Fields list and click the Add button.

5.  Select any fields you want to remove from the Displayed Fields list and click the Remove button.

6.  Use the Up and Down buttons to move the fields into your preferred order.

7.  Click the Save button.

Warning: Project Server 2007 only offers a limited number of fields for use on the My Timesheet page. If you select the Remaining Work field, you must also select the Time Entry by Timesheet Only option on the Task Settings and Display page to unlock the Remaining Work field for editing on the My Timesheet page.

The Project Server administrator must complete the following steps to add columns to the My Tasks page in Project Web Access:

1.  Log into Project Web Access with administrator permissions.

2.  Click Server Settings > Manage Views.

3.  In the My Work section, click the My Assignments view to open it for editing.

4.  Select one or more fields in the Available Fields list and click the Add button.

5.  Select any fields you want to remove from the Displayed Fields list and click the Remove button.

6.  Use the Up and Down buttons to move the fields into your preferred order.

7.  Click the Save button.

Resolution for Project Server 2010

Project Server 2010 offers two different pages for reporting time and task progress, which are the Timesheet page (used for reporting all types of time) and the Tasks page (used only for reporting task progress). Because of this, the Project Server administrator may need to complete two different sets of steps to add a column to either page. To add a column to the Timesheet page, the Project Server administrator must complete the following steps:

1.  Log into Project Web Access with administrator permissions.

2.  Click Server Settings > Manage Views.

3.  In the Timesheet section of the page, click the either the My Timesheet view or My Work view to open it for editing.

Note: Project Server 2010 offers two PWA views for the Timesheet page. The My Timesheet view contains only a few columns, while the My Work view contains many columns. The My Work view is very useful if your organization is using the Single Entry Mode (SEM), which allows users to enter time and task progress together in the Timesheet page.

4.  Select one or more fields in the Available Fields list and click the Add button.

5.  Select any fields you want to remove from the Displayed Fields list and click the Remove button.

6.  Select any field and then click the Up and Down buttons to move the fields into your preferred order.

7.  Select any field and optionally set a value in the Column Width field.

8.  Select any field and optionally add a custom column name in the Column Label field.

9.  Select any editable field and optionally select the "Make column read only" option.

10. Click the Save button.

The Project Server administrator must complete the following steps to add columns to the Tasks page in Project Web Access:

1.  Log into Project Web Access with administrator permissions.

2.  Click Server Settings > Manage Views.

3.  In the My Work section, click the My Assignments view to open it for editing.

4.  Select one or more fields in the Available Fields list and click the Add button.

5.  Select any fields you want to remove from the Displayed Fields list and click the Remove button.

6.  Select any field and then click the Up and Down buttons to move the fields into your preferred order.

7.  Select any field and optionally set a value in the Column Width field.

8.  Select any field and optionally add a custom column name in the Column Label field.

9.  Select any editable field and optionally select the "Make column read only" option.

10. Click the Save button.

 

Stay Connected

Join Our
LinkedIn Network
Follow Us
on Twitter

About FAQs

Microsoft Project Server Frequently Asked Questions (FAQs) provide information about Microsoft Project Server 2002, Microsoft Project Server 2003, Microsoft Project Server 2007, and Microsoft Project Server 2010.

Topics include common errors and the Project Server queue, project manager and resource manager approvals, enterprise calendars, enterprise custom fields, enterprise projects and the enterprise resource pool, user access, reports and OLAP analysis, resource work, project costing, task progress reporting and timesheets, Project Web Access (PWA) and Project Professional, check-out check-in and the local cache, saving and publishing, and issues risks deliverables documents and project workspaces.

About This Site

Project Server Experts (www.projectserverexperts.com) is an online community that provides answers to Project Server Frequently Asked Questions, allows members of the Project Server community to connect with one another by uploading their Business Cards, provides links to online Project Server resources, and links to Microsoft Project and Project Server related jobs.

This site is brought to you by MSProjectExperts. If you find the information posted here useful, please consider visiting our commercial site (www.msprojectexperts.com) for Project Server books, Project Server training and Project Server consulting services. Please support our sponsors. Thanks. -- The MSProjectExperts Team

Submissions

We welcome content submissions. We give author credit and cross link on all accepted articles. Please send your articles and suggestions to info(at)msprojectexperts.com.

Copyright

Reproduction of content on this site is strictly prohibited without the express permission of MSProjectExperts. Copyright (c) 2011 CHEFETZ LLC. All rights reserved