NOT
NOT(a)
Turns TRUE into FALSE and FALSE into TRUE, such as "has successors" from "has none". A blank stays blank: NOT of an unknown is still unknown, so it never turns a blank into TRUE. You can also write it before a condition without parentheses: NOT [Critical].
Arguments
| Argument | What to give it |
|---|---|
| a | A TRUE/FALSE value: a comparison, a yes/no field like [Critical], or a function such as ISEMPTY or CONTAINS. |
Examples
Formula=NOT([Critical])
TRUE on every task off the critical path.
Formula=NOT(ISEMPTY(Successors))
TRUE on tasks that lead into something. FALSE marks the open ends.
Formula=NOT(CONTAINS([Name], "milestone"))
Tasks whose name doesn't mention a milestone.
Reach for something else when
| You want | Use |
|---|---|
| "Not equal" in a comparison | the <> operator: [Status] <> "Complete" |
| TRUE when a value is blank | ISBLANK |
| None of several conditions | NOT(OR(…)): see OR |
Common questions
What does "NOT needs TRUE/FALSE" mean?
The value is a number, a date or text, and none of those is TRUE or FALSE. Compare it first: NOT([% complete] > 0).
=NOT([% complete])