Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Counting Checkboxes of all Parent rows in a sheet
We have a sheet that has a multiple level hierarchy. One of the columns is a checkbox and I used the formula ="" + COUNTIF(CHILDREN(), 1) to count the number of checkboxes below each parent row. This created the number of checked box in the parent row. Is there then a way to count all the numbers in the parent rows (to get a total amount of checkboxes in all hierarchies in the sheet)? I have tried several formulas, but none have worked. Thanks in advance!
P.S. The SUM formula alone does not work.