Author: Ismet Kocaman

Ismet Kocaman, MCTS, PMP, is a Mechanical Engineer and has more than 15 years of project management experience in the manufacturing sector. He currently provides consultancy to small to mid-sized companies on project management, reorganizing, and streamlining the manufacturing operations. He also conducts training seminars for engineers on MS Project. Contact Ismet at ikocaman.pm@gmail.com.

Filter for Tasks Taking Place Outside of 8 to 5

If you want to identify which tasks don’t start at 8 a.m. and don’t finish at 5 p.m., here’s how: Enter the following formula to a custom flag field, for example, Flag1, and then filter for tasks whose Flag1 field doesn’t display Yes: Format( [Start], “hh:nn AMPM” ) & ” ” & Format( [Finish], “hh:nn AMPM” ) Like “08:00 AM 05:00 PM” The filter will also work for manually-scheduled tasks whose Start and Finish fields contain valid dates.

Show Physical % Complete on Your Task Bars

To illustrate how much of a task is done when you’re working with Microsoft Project, just insert a PHYSICAL % COMPLETE line to the Bar Styles dialog box as shown below. Note that Project doesn’t draw a PHYSICAL % COMPLETE bar if the Actual Start is NA.    

Get a Quick View of a Custom Field Formula

If you’re using Project 2010 or Project 2013, use the following subroutine to display the formula in a custom field: ‘ © Ismet Kocaman ‘ Sub Show_Formula() If Application.CustomFieldGetFormula(ActiveCell.FieldID) <> “” Then MsgBox Title:=”Field: ” & ActiveCell.FieldName, Prompt:= _ Application.CustomFieldGetFormula(ActiveCell.FieldID) Else MsgBox Title:=”Field: ” & ActiveCell.FieldName, Prompt:= _ “No Formula” End If End Sub To add this subroutine to a project plan file, follow these steps: 1. Open a blank mpp file and save it with a new name, such as “ShowFormula.mpp”. 2. Click Alt-F11 to open Visual Basic Editor. 3. Click VBAProject(ShowFormula.mpp) on the left and open the Insert menu from the menu bar. 4. Click Module to insert a module. 5. Click Module1 (or the module inserted) on the left, and copy the subroutine above and paste it into the Module1 window on the right. 6. Close Visual Basic Editor. To add a button for the subroutine to the Quick Access Toolbar, do this: 1. Click the File tab and select Options to display the Project Options dialog box. 2. Click the Quick Access Toolbar and select Macros in the Choose commands from drop-down. 3. Select ShowFormula.mpp|Show_Formula on the left and click Add in order to add ShowFormula.mpp|Show_Formula to the command list in the Customize Quick Access Toolbar box on the right. 4. Use Modify to select any icon that you like and enter a display name for the subroutine. 5. Click OK to close the Project Options dialog box. Now the icon for the subroutine will appear on the toolbar. Click a custom field containing a formula and then click the button for the Show_Formula to see how it works.

Use Your Mouse to Change the Duration Value

In all versions of Project, in a task line, click a Duration cell to activate the spin button control and then click the arrows to increase or decrease the duration value in the cell. Each click changes the duration by one day. The Duration cell initially displays “1 day?” for a new task entry by default. The question mark sign (estimated duration label, “?”) in the cell disappears by the first click of any arrow.

Display Project Info and Task Count without Project

In the active project plan file, apply the proper command sequence to open the File Properties dialog box. In Project 2013, that’s File > Info > Project Information > Advanced Properties. 1. On the Custom tab, enter a name for the information you want to display.2. Select a Type and select the checkbox Link to content. The Source box will display the project summary task fields that can be linked to the custom information specified in the Name box.3. Click Add to include the custom information defined to the Properties box.4. Click OK to close the dialog box and exit Project by closing the file. In order to test this, locate the file on the computer and right-click its desktop shortcut or filename in the folder to open the File Properties dialog box. The Custom tab will show the information that has just been added, even in a system with no Microsoft Project installation! If you want to display your task count without opening your project file, follow these steps. 1. Do the steps above to add the Contact field (Name: TASK COUNT, Type: Text, Source: Contact) to the Custom tab of the File Properties dialog box.2. In Project, select Use formula to enter this: iif( [ID] = 0, [Task Count], 0 ) to the task custom number field Number20.3. Next, open the Project Summary Task, right-click Number20 in the project summary row, select Copy Cell, then right-click Contact cell of the project summary task and apply Paste Special > Paste Link > OK. Now Contact field will display the task count of the project. In order to test this, locate the file on the computer and right-click its desktop shortcut or filename in the folder to open the File Properties dialog box. Again, the Custom tab will show the information that has just been added, even in a system with no Microsoft Project installation.

Quick-check the Revision Number and Last Saved Info

Here’s how you can see the revision number and “Last saved by” information of a Project file without opening it: 1. Right click the desktop shortcut of the Project file (or the filename in the folder) and select Properties on the menu to open the File Properties dialog box. 2. Click the Details tab to see how many times the file has been saved (that is, “Revision number”) and the user account name of the last saver (“Last saved by”).

2 Keyboard Shortcuts for Microsoft Project

1. Here’s a keyboard shortcut for any version of Project: Click F4 and T on the keyboard to quickly enter today’s date into any date field in a table: 2. In all versions of Project, use the keyboard shortcut Ctrl-D in order to fill in fields with the data selected in a table (all versions). But wait — there’s more! Here are two other methods to replace or copy the data in a table. First, use the Replace command (Task > Editing > Replace) to locate and replace the data quickly in a table. Second, drag the fill handle down to copy the selected data to the consecutive cells in the rows below.

Creating a Custom Report in Project 2013: This Week’s Tasks

This document is related to the standalone desktop editions of Project 2013. Project 2013 contains some new built-in task filters such as Tasks Due This Week, Tasks Starting Soon, and Milestones Due This Month. We can see a list of all predefined task filters in the More Filters dialog box, and the steps to open the More Filters dialog box are as follows: On the VIEW tab, in the Data group, click the Filter drop-down and click More Filters…, Select the Task option and review the filters in the Filters list. Next, we can see the filtering criteria of any predefined task filter in the Filter Definition dialog box (except for the Using Resource filter) as follows: select the name of the filter and then click Edit… in the More Filters dialog box. The three filters mentioned above contain prompt texts (e.g. “message“?) below the Value(s) column in the Filter Definition dialog box. On the other hand, Project 2013 does not request any date information when we apply any of these task filters to a task view. For example, Project 2013 does not request the dates, “Start of the week” and “End of the week”, when we apply the filter Tasks Due This Week to a task list. Apparently, Project 2013 automatically feeds the required dates into these filters, according to the current date entered (or coming from the system clock by default) in the Project Information dialog box. Also, some built-in reports (the new graphical reports) using these filters do not prompt for any date information, as we would expect: The Upcoming Tasks report is a “Dashboards” category report. In this report, the Tasks Due This Week and Tasks Starting Soon filters are applied to all subtasks in the charts, Remaining Tasks and Tasks Starting Soon, respectively. The Milestone Report is an “In Progress” category report in which the Milestones Due This Month filter is applied to all subtasks in the Milestones Up Next table. Note on the Filters list that we do not see three dots (that is, an ellipsis character, indicating that we need to provide further information to the filter) after the name of the three filters mentioned above, unlike the other interactive filters, such as the Date Range filter. CREATING A CUSTOM TASK FILTER Having discovered this behavior, a custom task filter named THIS_WEEKS_TASKS can be created by using the criterion rows below in the Filter Definition dialog box: Follow the steps below to create the filter: On the VIEW tab, click the down arrow of the Filter box in the Data group to display the drop-down menu and then select New Filter in the menu to open the Filter Definition dialog box. Enter the lines representing the filtering criteria into the Filter Definition dialog box as given in the table above and click Save. Watch the video here at Creating THIS_WEEKS_TASKS filter (no narration). CREATING A CUSTOM REPORT USING THE CUSTOM TASK FILTER ALREADY DEFINED The custom filter, THIS_WEEKS_TASKS, can be applied to any task view. Let’s now discuss how to create a custom report using the THIS_WEEKS_TASKS filter. The report will contain a table listing selected task fields of this week’s tasks and will also display the current date. Follow the steps below to create a custom report in a simple schedule, such as the one shown in the picture at the top of the page: Opening a blank table report: REPORT | New Report | Table | enter <THIS_WEEKS_TASKS> into the Name box in the Report Name dialog box | OK Project will now open an empty table report with default elements; a title box with report name and a table with some task fields. Customizing the report title and inserting a text box: Click the report title; the FORMAT tab will now show the DRAWING TOOLS heading. Now customize the report title using the drawing tools. Also add a text box containing the text “Current Date:” into the report by using the Text Box command in the Insert Shapes group or use Shapes command in the Insert group of the DESIGN tab below the REPORT TOOLS heading. Right-click on the title box or the text box for further formatting. Watch the video here at Create This Week’s Tasks Report – Title (no narration) Customizing the table: Click the default table displayed on the report screen; Project 2013 will now show DESIGN and LAYOUT tabs below the contextual ribbon heading, TABLE TOOLS on the ribbon and the Field List pane (the Table Data taskpane) on the right part of the report screen. We can move and resize the Field List pane on the report screen by using the mouse. We can hide the Field List pane by either clicking the Close command on the Task Pane Options menu (down arrow) or the Close button (X) at the top right corner of the pane; and then clicking the Table Data in the Show/Hide group on the (TABLE TOOLS)DESIGN tab shows the Field List pane. Set the Filter box to [THIS_WEEKS_TASKS] and the Outline Level box to [All Subtasks]. Select Fields box has two sections; in the first section, we can select any task field to display on the table. The second section will display the fields selected; here, right-click on any task field name to open the shortcut menu or drag-and-drop a task field to change the column order. Right-click on the table or use the table tools on the ribbon to customize the appearance of the table. Watch the video here at Create This Week’s Tasks Report – Table (no narration) Inserting a second table to display the current date: Next, click Table in the Insert group on (REPORT TOOLS)DESIGN tab and then select the date-typed custom task field, Date1 on the Field List pane. Remove the other task fields already added by default. Make sure that the Outline Level box contains [Project Summary]. Click the DESIGN tab below TABLE TOOLS and then clear the checkboxes, Header Row and Banded Rows in the Table Style Options group. Reposition the second table next to the text box containing the text “Current Date:”.   Customizing the custom date field, Date1 to pass the current date information into the report: The second table will initially display “NA”. Click Gantt Chart in the View group on (REPORT TOOLS)DESIGN tab and then click Custom Fields in Properties group of the PROJECT tab… In the dialog box displayed, insert the field reference [Current Date] into the formula box for the custom task field Date1, and also select Use formula option in the “Calculation for task and group summary rows” section. Close the dialog box. Switch to the report screen by using REPORT | Recent | select [THIS_WEEKS_TASKS]. The table inserted will now display the current date. Watch the video here at Create This Week’s Tasks Report – Final (no narration) TESTING THE CUSTOM REPORT CREATED After having created the custom report in a simple schedule by completing the steps above, we can test the custom report for different weeks by manually changing the current date in the Project Information dialog box. A picture of the report can be copy-pasted into the other documents by using the Copy Report command in the Report group of (REPORT TOOLS)DESIGN tab. Project 2013 displays the tasks of the current week whenever we open the custom report and we do not need to enter the start and the end dates of the current week; instead, Project 2013 will automatically feed the proper dates to the custom filter. Note on the combination view of the simple plan shown in the picture at the top of the page; the custom filter can also be applied to the Gantt Chart view on the bottom pane. As soon as we change the current date, Project 2013 automatically updates the custom report and the Gantt Chart view (just set focus to the bottom pane and reselect the same filter) accordingly. The custom filter will prompt for the dates before displaying the report if we change the “intelligent” prompt texts, for example, by inserting a space right after “is:”. We can also use the Date Range filter in the report to list the tasks of other weeks or date ranges by simply entering the start and the end dates when prompted. The other “intelligent” filter prompt texts tested so far are as follows:“Today is:”?, “Start of the month is:”?, “End of the month is:”?. Stay tuned for my next article: Creating a Custom Report in Project 2013: Work Distribution Report with Hours and Percentages.   Disclaimer The information contained in this document is intended only for the general interest of its readers and should not be used as a basis for making any business or other important decisions. Though all the efforts have been made to create accurate content, mistakes can occur. The author of this document cannot, therefore, guarantee the accuracy of content. The author of this document disclaims all warranties and must advise you to use this document at your own risk. The author of this document is not liable for loss of any nature resulting from the use of or reliance upon the information found therein. Screen captures were reprinted with authorization from Microsoft Corporation. This document is not a product of Microsoft Corporation.

  • 1
  • 2