Pigment AI Agents are here! Starting today, we’re launching new AI Agents and updating our documentation for them. Some pages may look different or redirect to new resources. Send us feedback through "Was this article helpful?" at the foot of the page

COUNTBLANKOF function

  • Published on Aug 22, 2025
  • 1 minute(s) read
Prev Next

​​​Description

Counts the number of BLANK values of a Block.

Syntax

COUNTBLANKOF(Block)

Arguments

Argument

Type

Dimensions

Description

Block

(required)

Any

Any

Returns

Type

Dimensions

Integer

No Dimension

Examples

Employee is a Dimension List:

Formula

Result

Description

COUNTBLANKOF(Employee)

0

For a List, no item is counted as BLANK.

COUNTBLANKOF(Employee.Name)

1

The Property Name contains 1 BLANK value.

See also

Excel: COUNTBLANK

Related articles: COUNTALLOF, COUNTOF, COUNTUNIQUEOF

More of a hands-on learner?

Talk to your Customer Success Manager about downloading the Functions and Modifiers in Pigment Application into your workspace. It includes examples of every formula and modifier in Pigment!

Related articles