COUNTBLANK
Returns the number of blank values in a dataset.
Parameters
value
Array (required) - an array of items
Returns
Number - the number of blank items in the array
Examples
// since null and '' are blank values
COUNTBLANK([null, null, '', 1])
// returns 3
Updated almost 2 years ago
Did this page help you?