1. Calculation functions
  2. All Functions
  3. Logical Functions
  4. ISNOTBLANK

The ISNOTBLANK function returns a Boolean result for values that are not blank.

For example, you can use the ISNOTBLANK function to find employees without a leaving date.

Syntax

ISNOTBLANK(Value to test)

Arguments

ArgumentData typeDescription
Value to testDate, time period, text, or listThe value to test if it is blank.

The ISNOTBLANK function returns a Boolean result.

Syntax example

ISNOTBLANK(Panel interview)

In this example, Panel interview is a line item with a text format. The formula returns true if a value from the line item contains text, which means a candidate has completed that stage of the interview process.

Excel equivalent function

Related Anaplan functions

Examples

ISNOTBLANK(Rehire date)

In this example, Rehire date is a line item with a date format. The formula returns true for values that contain dates for rehired employees.


Hannah SmithEric JonesPaul Turner
Rehire date5/06/2021
8/03/2021
ISNOTBLANK(Rehire date)