COUNTALL

Use the COUNTALL function to get the total number of items in any type of array.

Use

COUNTALL( array )
Count all items in the array, including blank items.

Parameter	Required	Description
array	Yes	an array of any type

Returns

Number

Use with literals

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

returns 4

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

returns 6

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

returns 6

COUNTALL({TRUE, FALSE, BLANK})

returns 3

Use with fields

COUNTALL(@Review.out.Notes)

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