Adding a dependency from a spreadsheet

A dependency (often called a linked task) determines how a task in a task plan is scheduled, in relation to all other tasks in the task plan. A dependency is based on a task's start date and/or finish date. A dependency that determines how other tasks in a task plan are scheduled is called a predecessor. A dependency that relies on another task's start date or finish date to determine how it can be scheduled is called a successor.

To add a dependency from a spreadsheet

  1. Open the Projects module.
  2. Select an item.
  3. Select the Task Plan tab.
  4. In the task plan, select a column header, right-click, and select Insert Column.
  5. In the Insert Column dialog box, select the Predecessors or Successors columns from the Field drop-down.
  6. In the Predecessors or Successors columns, enter the dependency. For example, a finish-to-start dependency relationship with task 3 in the task plan, and a lag of 2 days would be 3FS-2 days.