How might one count non blank cells in a non-contiguous range in Smartsheet? =SUM(COUNTIF(INDIRECT({'Range","Range"}),"<>" & "")) is not supported. Thanks.
I was able to do a work around with a lengthy IF(LEN(...statement. Still looking for a more condensed solution.
If you want to count the number of non blank cells in multiple ranges, try this:
=COUNT(range:range, range:range, range:range)
