Skip to main content
Go Search
MPUG Home
Membership
Resources
User Group Chapters
Knowledge Library
About MPUG
MySite
  

 

Ask the Experts: Applying Two Constraints on One Task 

News Archive
Ask the Teacher: Earned Value Doesn’t Want to Calculate
Setting Recurring Non-working Time in Microsoft Office Project Standard 2007
Back to the Future
Ask the Teacher: Substituting Resources, Plus Changing the Current Date
4 Formulas for EPM Disaster
Ask the Experts: Define Critical
Oracle on Track to Buy Primavera
Ask the Experts: Why Self-Taught with Microsoft Project Isn't Such a Great Idea
Laying the Foundation for Leading a Project Management Office
Mail: Another Perspective on Defining "Critical"
Certification Insider: Creating a Project from an Existing One
A Rational Approach to Padding
Ask the Expert: Accounting for Material Resources
Chapter Spotlight: 3 Questions with London's Dharmesh Patel
Olympian Stephanie Trafton Connects Winning the Gold with Project Management
5 Compelling Reasons to Upgrade to Project 2007: Visual Reports
Ask the Experts: Displaying Availability Exceptions in Resource Usage Sheet
Certification Insider: How Calendars Control Schedules
Chapter Spotlight: 4 Questions with Houston's Vicki Eaker
The 30-second Report
Ask the Expert: Separating Time Completed from Work Completed
Certification Insider: Defining Working Times with Project 2007 Calendars
Columns I'd Like to See in Project
PMI Releases Updates to Four Standards
How to Reduce Your Project Costs
Ask the Expert: Custom Reports in Microsoft Project
The Work Breakdown Structure
The Strategies of Microsoft Project and Project Server
Certification Insider: Ready! Set! Start Creating Tasks!
Track Project Progress with Physical % Complete
Putting Project Portfolio Management to Work in a Bad Economy
Chapter Spotlight: 4 Questions with Twin Cities' Larry Christofaro
11 Reasons You Should Attend the Microsoft Project Conference
The Case of the Broken Task in Microsoft Project
Ask the Expert: Importing Data from Excel into Project
Certification Insider: Arranging Tasks
Ask the Expert: When Scheduling, Start at the Beginning
Chapter Spotlight: 3 Questions with Baltimore-Washington Metro's Gerald Leonard
Ask the Expert: Tips for Getting Project Server Buy-in from Users
Migrating to Microsoft Project Server 2007: Lessons from the Field
How Gantt Chart-Literate Are You?
Develop Your Project Management Skills: Scenes in the Negotiation Play
Ask the Expert: Optimize Microsoft Project Performance
Ask the Expert: Creating a Limited Resource Availability Schedule
Scheduling Master: Finish to Start Successors
How Gantt Chart-Literate Are You: The Puzzler Solution
The Power of Local Resources in Microsoft Project Server
Certification Insider: How To Influence Tasks and Win Friends (in Microsoft Project)
Ask the Experts: When % Complete Won't Calculate
Ask the Experts: Making Interim Plans Work for You
Project Budgeting: Money Changes Everything
Ask the Experts: How Resource Sharing Works in a Master Project
5 Principles of Program Management for the London Olympics
Certification Insider: Resourcing Project Plans
How to Replace Generic Resources with Named Resources
Ask the Experts: Building What-if Slack Time into Your Schedule
Automated Governance for Portfolio Management
Earn Your PMI-SP, Part 1: Explore the Credential
Share the Love! MPUG Community Leader Awards
Creating Microsoft Project Custom Toolbars in 4 Steps
Certification Insider: Assigning Resources in Microsoft Project
Ask the Experts: When Linking Summary Tasks Makes Sense
Earn Your PMI-SP, Part 2: The Application Process and Getting Through the Exam
Working the Numbers: How to Inject Financial Savvy into Project Management
MPUG Thanks Community Leaders in Award Ceremony
Tips and Tricks for Microsoft Project 2007: Creating Useful Custom Views
Ask the Experts: Applying Two Constraints on One Task
Earn Your PMI-SP, Part 3: What You Need to Study
Best Practices for Microsoft Project, Part 1
Best Practices for Microsoft Project, Part 2
Certification Insider: Mastering Duration, Work, and Units
Creating Milestone Reports in Microsoft Project
Ask the Experts: Managing That Schedule with Drop-dead Deadlines
The Project 2010 Interview: Microsoft's Chris Capossela Talks to the Microsoft Project Community
How to Restore an Abandoned Project Schedule
Certification Insider: Modifying Resource Assignments
Why MPUG: Five Perspectives, One Member
The Purpose of Project Charters
Forecasting Schedule Issues with a Deadline Dashboard
Ask the Experts: Printing Notes in a Project
How to Achieve a More Realistic Schedule in Your Project Planning
Is Microsoft Project a Project Management Tool?
The New Year's Resolution of a Project Manager
Certification Insider: Understand Critical Path
Project Programming: Integrating Project Server's Timesheet with an Access Control System
Ask the Experts: What's Going on This Week?
Critical Path 2.0
Certification Insider: Exchanging Data between Programs
ProjecTalk Goes On the Air!
Ask the Experts: Making Sense of Current Activity Reports
Three Rules for a Happy Life with Project 2007
Project Date Numbering
Sign Up for MPUG Chapter Alerts!
MPUG Members: Tell Us What You're Going to Love about Microsoft Project 2010 -- and Get a Free Copy of the Software!
Microsoft Project 2010: Preparing for Launch
Certification Insider: Saving and Modifying Baselines
Ask the Experts: Creating a Report with Task and Resource Data
Microsoft Project 2010 Licensing
Microsoft Project 2010 Upgrade Path
Project Server 2010: Things to Note, and Avoid, as You Start the 2010 Journey
5 Tips for Formatting Text on a Gantt Chart
Microsoft Project 2010 Feature Rally: Sync to SharePoint
Microsoft Project 2010 Feature Rally: Manually Scheduled Tasks
Microsoft Project 2010 Feature Rally: Departmental Fields
Microsoft Project 2010 Feature Rally: Inactive Tasks
Microsoft Project 2010 Feature Rally: Team Planner
Microsoft Project 2010 Feature Rally: Reporting
Microsoft Project 2010 Feature Rally: The Ribbon
Microsoft Project 2010 Feature Rally: Synching with SharePoint
Microsoft Project 2010 Feature Rally: Project Timeline
Microsoft Project 2010 Feature Rally: Integrated Portfolio Management
Microsoft Project 2010 Feature Rally: No More ActiveX!
Microsoft Project 2010 Feature Rally: ROG, the Red Over-allocation Guy
Certification Insider: Making Resource Assignments Realistic
Ask the Experts: Exporting Only Tasks to Excel
The Great Demo! Top 10 List
The Great Demo! Top 10 List
Microsoft Project View Mastery
EPK Cost Tackles Cost Management for Microsoft Project Server
Lock Down Microsoft Project Progress Data
Certification Insider: Resource Overallocations
Don't Touch That Dial! What to Do Before Using Microsoft Project
Ask the Experts: Managing a Large Number of Resources
10 Easy Ways to Earn PDUs
The Awful Demo: Top 10 List of What NOT to Do
How to Get Certified in Microsoft Project 2010
Microsoft Project 2010 Certification FAQ
 
 

Adenor from Oakbrook, IL asks: I have a task in a schedule that must start after an unknown date and must end on a specific date. I've tried to enter a start and finish date on the task, but it doesn't seem to be working for me. After the task starts, it'll take nine days including weekends. How can Microsoft Project schedule this task for me?

Answer: Project can certainly do this for you. Let's take your problem one step at a time.

First, the need for start and finish dates. Since you can't enter both a start and a finish date on a task, you can enter a "start no earlier" date to push the task forward in time and deadline. This will give you the ability to start the task after some date in the future and have a target for the ending date of the task.

To enter these values and dates:

  1. Double click on the task.
  2. Select the Advanced tab.
  3. Enter the deadline date.
  4. Select the Start no Earlier than Constraint.
  5. Enter the constraint date. Choose a date sometime in the future when you think it might start.
  6. Click OK.

Figure 1 shows how it would look with both constraints applied to a task.

Figure 1. Setting a "start no earlier" date constraint.

Lehnert Figure 1

In this example I've also changed the Gantt chart to show the start no earlier date below the Gantt bar for the task, the constraint type above, the finish date to the right, and the deadline date to the right of the deadline on the task.

To create this formatting, right-click on the Gantt bar for the task and select Format Bar, then select the settings you see in the form in Figure 2. Using this method you would make changes on a Gantt chart for a single task bar.

The deadline date was added by: Format | Bar styles | Deadline | Text (in the bottom part of the form) | Deadline | OK. This is a change that will affect all deadlines applied to this Gantt view.

If the date format isn't what you would like, you can make changes in Format | Layout.

Figure 2. The Format Bar property dialog.

Lehnert Figure 2

The second part of your question asks about showing the task as nine days in duration, including weekends. When duration is entered, the system looks at the project calendar and uses availability according to that calendar, usually set for business days, which doesn't include weekends. This can be overridden so that the task will use the physical number of days -- both working and non-working. This feature is called elapsed time. Enter the duration as "9 ed" instead of "9d" to have physical days counted. See the comparison example in Figure 3.

Figure 3. Entering an elapsed time to count physical days with "ed" instead of "d."

Lehnert Figure 3

When the task starts to execute, I would recommend entering the actual start date to see how it compares against the deadline date and moving it forward to reflect what actually occurred. Your goal will be to not let the end of the task cross the deadline.

My recommended steps for scheduling the task to fit your needs are:

  1. Enter a start no earlier constraint.
  2. Enter a deadline for the task.
  3. Enter the duration using elapsed time (9 ed) to get physical days.
  4. Enter the actual start date of the task.
  5. Make sure that the end of the task doesn't cross the set deadline.

Email your question for our experts to editor@mpug.com.

Columnist Ellen Lehnert


With over 20 years of corporate training experience, Ellen Lehnert, PMP, MCT, MCITP, is a specialist in Microsoft Project and Microsoft Project Server. She contributes to many reference books and holds multiple Microsoft Project certifications. Ellen brings a unique combination of licensed teacher and programming background to the classes she teaches as well as process development, installations, and consulting. Contact her at ellen@lehnertcs.com.


 

© Copyright 1997-2010 MPUG.com. All Rights Reserved. Privacy Policy - Contact Us