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

 Argument Data type Description Value to test Date, time period, text, or list The 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.

## Calculation engine functionality differences

In Polaris, the ISNOTBLANK function considers a text value that consists exclusively of carriage return characters to be a blank value.

In the Classic Engine, the ISNOTBLANK function considers a carriage return to be a non-blank value.

## 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 Smith Eric Jones Paul Turner Rehire date 5/06/2021 8/03/2021 ISNOTBLANK(Rehire date)

Disclaimer

We update Anapedia regularly to provide the most up-to-date instructions.