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 Check Boxes

edited 12/09/19 in Archived 2015 Posts

I'm trying to get a formula to count the number of Check Boxes that are checked in all the Children rows under a Parent row.


When using ="Count:" + COUNTIF(CHILDREN(), 1), which is one of the formula examples I'll get this Count: 2


All I'm looking for is the number so I tried =COUNTIF(CHILDREN(), 1) but it doesn't work.  All I get back is #1 or 0 EXPECTED.


Any help would be appreciated.  Thanks.



This discussion has been closed.