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

Examples

Multi-Value Validation (Ensuring Completeness)

In a form where a user provides an array of values—such as a list of "Action Items" or "Project Notes"—you can use COUNTBLANK to ensure that every row the user added has actually been filled in. This is applied as an Output Validation Formula.

• Formula: COUNTBLANK(this) = 0
• Logic:
  • this: Refers to the array of data currently being validated.
  • The formula checks the number of blank items in that array. If the user added five rows but left one empty, COUNTBLANK returns 1.
  • Since 1 does not equal 0, the formula returns FALSE, and the user will be prevented from submitting the form until the empty row is either filled or removed.

Path Condition (Routing Based on Missing Information)

You can use COUNTBLANK on a Branch step to determine the path of an approval based on how much information was omitted in a preceding step.

• Scenario: A trigger form collects a list of "Client Requirements" in a Text Array. If more than two requirements are left blank, the approval should be routed to a "Discovery Phase" rather than proceeding to "Technical Review."
• Formula: COUNTBLANK(@Trigger.out.ClientRequirements) > 2
• Logic:
  • @Trigger.out: Accesses the output data produced by the trigger step.
  • If the count of blank items in that specific array is 3 or more, the condition is TRUE, and the workflow follows the specified path.