COUNTBLANK

Use the COUNTBLANK function to get the number of blank items in any type of array.

Use

COUNTBLANK( array )
Counts only blank items in an array.

Parameter	Required	Description
array	Yes	an array of any type

Returns

Number

Use with literals

COUNTBLANK({1, 2, 3, BLANK})

returns 1

COUNTBLANK({"a", "b", "1", "2", "", BLANK})

returns 2

COUNTBLANK({DATE(2024,1,1), BLANK})

returns 1

COUNTBLANK({TRUE, FALSE, BLANK})

returns 1

Use with fields

COUNTBLANK(@Review.out.Notes)

if field @Review.out.Notes contains 4 items but one is blank, returns 1