OR
OR(a, b, …)
TRUE when any condition is TRUE, such as a task that is critical or close to it. A blank condition doesn't count as FALSE: one TRUE makes the result TRUE whatever else is blank, but FALSE with a blank is blank. You can also write it between two conditions: [Critical] OR [Total float] < 5d.
Arguments
| Argument | What to give it |
|---|---|
| a, b, … | One or more TRUE/FALSE values: comparisons, or yes/no fields like [Critical]. |
Examples
Formula=OR([Critical], [Total float] < 5d)
Tasks on the critical path or within five working days of it.
Formula=OR([Critical], ANY(Predecessors[Critical]))
Critical tasks and the tasks a critical task leads into.
Formula on relationships=OR([Lag] < 0d, [Type] = "SF")
On a relationship: a lead or a start-to-finish link, the two a schedule review usually questions.
Reach for something else when
| You want | Use |
|---|---|
| All of the conditions, not any | AND |
| TRUE when a condition holds for any row of a set, such as any predecessor | ANY |
| The opposite of a condition | NOT |
Common questions
What does "OR needs TRUE/FALSE values" mean?
One of the arguments is a number, a date or text. Compare it with something to make it TRUE or FALSE.
The editor refuses this=OR([Critical], [Total float])
Why is OR blank on some rows?
Every condition there was FALSE or blank, and at least one was blank. OR([Critical], [% complete] > 50) is TRUE on every critical task, and blank on a task that isn't critical and has no % complete.