ROWS
ROWS(list)
Turns a column of rows into a set of those rows, such as every task that some relationship leads into. Each row appears once, however many times the list names it, and the set is in schedule order, not the list's.
Arguments
| Argument | What to give it |
|---|---|
| list | A column whose values are rows: Relationships[Successor], PredecessorLinks[Predecessor], Predecessors[Driver]. Blank values are skipped. A list of numbers, text or links isn't accepted. |
Examples
Formula=COUNT(EXCEPT(All, ROWS(Relationships[Successor])))
How many tasks in the schedule nothing leads into: every task, less the successors of all relationships.
Formula=INCLUDES(ROWS(Relationships[Predecessor]), [Task])
TRUE when the task leads into at least one other task.
Formula=COUNT(ROWS(Predecessors[Driver]))
How many different tasks drive this task's predecessors.
Measure (on the project)=COUNT(ROWS(Relationships[Successor]))
As a measure: how many tasks have at least one predecessor.
Reach for something else when
| You want | Use |
|---|---|
| How many entries the list has, repeats included | COUNT of the list itself |
| How many different values a list holds | COUNTDISTINCT |
| The tasks at the far end of a task's links | Predecessors and Successors are already sets |
Common questions
Why does the editor say "ROWS needs a list of rows"?
The list holds values, not rows. Read a field that is a task, such as a relationship's [Successor]:
=COUNT(ROWS(Relationships[Lag]))