TASK
TASK("code")
One task, named by its ID, so you can read its fields from any row: TASK("FINISH")[Finish date]. The ID must be text in quotes, written into the formula; it is checked when you save, and can't come from another field or column.
Arguments
| Argument | What to give it |
|---|---|
| code | A task ID in quotes, exactly as in the schedule: "BDC_001". |
Examples
Formula=TASK("MS_SUB")[Finish date]
The substantial-completion date, on every row: useful beside a task's own dates.
Formula=WORKDAYS([Finish date], TASK("FINISH")[Finish date])
The working time from this task's finish to the project finish.
Formula=INCLUDES(Upstream, TASK("BDC_001"))
TRUE for every task that BDC_001 feeds, directly or not.
Measure (on the project)=TASK("FINISH")[Total float]
As a measure: the float on the project finish milestone.
Reach for something else when
| You want | Use |
|---|---|
| A task that depends on the row, such as its predecessor | ONLY, FIRST or ARGMIN |
| A task that a user picks above the grid | INPUT with a task input, INPUT("Slipping task") |
| Every task with some value | FILTER or SAME |
Common questions
Why does the editor say “There's no task … in this schedule”?
No task has that ID. Check the spelling against the Task code column. If the task is deleted later, the formula shows an error on every row until you change it.
Why does the editor say "TASK needs text in quotes here"?
TASK only takes an ID written in quotes, so the editor can check it. It can't look a task up from a field:
The editor refuses this=TASK([Phase])[Finish date]
To find tasks by a field, filter: FILTER(All, All[Task code] = "BDC_001").
Is there a VLOOKUP?
No. TASK, the relations and FILTER reach other rows, and […] reads their fields.