Display the message “Tasks due shortly” in Project

 Jul 06, 2015

In project management, it is very important to know that a task is due to start shortly because of the following reasons:

  • You have to make sure that the necessary resource is still available
  • You have the required materials delivered on time
  • You have the required budget accessible when you need it

Microsoft Project can display this information for you by using a calculated customised field. Follow the steps listed below to create the “Task due shortly” field:

  1. Open the Project file you wish to use and display the “Gantt Chart view” with the “Entry” table displayed.
  2. Click the Project tab and click the “Custom Fields” button in the “Properties” group (or Columns group respectively). As you are in a task view, the “Task” option is already selected.
  3. We want to create a Text field. Select Type: “Text” and select the Text 1 field and rename it as “Task due shortly.”
  4. tasks-due-project-01
  5. Click the Formula button. We need to use an “If” function.
  6. Using the Function button, point on the General option and click the Iif(expression, truepart, falsepart) function name.
  7. tasks-due-project-02
  8. Double click expression and go to Field > Date > Baseline Start > Click Baseline Start.
  9. tasks-due-project-03
  10. Click after [Baseline Start] and type >now().
  11. Double click truepart and type “Task is due shortly”.
  12. Double click falsepart and type “Completed”. The formula should read: IIf ([Baseline Start]>now(),”Task is due shortly”, “Completed”)
  13. tasks-due-project-04
  14. Click OK. The message displayed is warning us that the existing data will be deleted. Click OK twice.

The next step is to insert the calculated field in the Gantt Chart – Entry table.

  1. Select the 'Start' field and press the 'Insert' button on the keyboard.
  2. Type “ta” and Microsoft Project will display the fields starting with ta (rather than you scrolling down the list).
  3. Click on 'Tasks due shortly.' The customised field is added to your table

tasks-due-project-05

If you are interested in learning more about Microsoft Project 2010 or 2013 functions and custom fields, I would recommend New Horizons' Microsoft Project 2010/2013 2-day training programs.

How do your Excel skills stack up?   

Test Now  

About the Author:

Magdalena Todor  

With over 20 years experience as a facilitator and university lecturer, Magda is one of our most senior and experienced trainers. With previous practical on the job experience as a project manager she embodies a brilliant balance of training experience and business knowledge. With every event she delivers, Magda takes a wholehearted approach to ensure every course is impactful, relevant and a genuinely positive learning experience for all.

Read full bio
top