
Feb 19, 2015
Microsoft Project 2010 and 2013 have a built in functions which provides the user with powerful tools to monitor their project progress. One of the common issues in Project Management, is the inability of the Project Manager to visually oversee the tasks which are due. This information would be beneficial to ensure that:- the human resources are available when they are needed
- the facilities are free to use when the tasks are due
- the Project Manager is always aware of the tasks scheduled ahead
- the project work is running as planned
- Open the project file you want to use
- Make sure you are in Gantt Chart view because you want to create a task field
- Click the Project tab
- Go to Properties group
- Click the Custom Fields The following dialog box will display:
- Select 'Text1'
- Click Rename button
- Type “Task due in 2 weeks”
- Click OK
- With the Task due in 2 weeks selected, click the Formula The following dialog box will display:
- Click Function button
- Point on the General option
- Click the IIF The function syntax will display as per the image below:
- Replace the formula with the following code:
IIf([% Complete]<100,IIf([Scheduled Finish]<(now()+14),"This task is due within 14days",""),"")
- Click Ok
- Click Ok
- Select the 'Start column/field'
- Press the Insert button on your keyboard
- Type 'Ta' to scroll fast to the customized field
- Click the Task due in 2 weeks The field should display the message “This task is due within 14 days” for the relevant tasks.
How do your Excel skills stack up?
Test NowNext up:
- Planning Exchange Online and Configuring DNS Records
- The Power of Zoom
- Security Compliance Manager Updated
- Me, Myself and I in the workplace
- What is a Concordance File?
- Hyper-V Network Types
- Windows To Go! Part 2.
- Screen Clip your Internet!
- Top 10 posts you may have missed from February
- HR for Non-HR Managers: Is the HR function necessary?
Previously
- What does Warren think about leadership?
- Windows To Go! Part 1.
- Innovations in Office 365
- Two DBAs walk into a NoSQL bar
- Manage emails in Outlook using the 4 Ds
- How to be positive and enthusiastic at work when you don't feel like it!
- Master mail merge to email in Microsoft Word
- Normalising your database: Third Normal Form (3NF) – Part 3
- Introduction to transitions and animations in PowerPoint 2010/13
- Control your code with GitHub