Page 106 - Customize-Project-Plan-by-tailoring-Smartsheet

Customize your Project Plan
   
by tailoring Smartsheet

36. Parent automatically checked off

36.1. Parent Checkbox checked if all children checked off

Let's write the following formula in the summary / parent cells of the column "Done". The formula in
the parent cell will then look down to their children tasks, and when all children checkboxes are
checked, then also the parent check box is going to be automatically checked.

=IF(COUNTIF(CHILDREN(Done@row), 0) = 0, 1)

More information on the internet:

https://help.smartsheet.com/articles/2476811-reference-children-parents-ancestors-hierarchy-func-
tions

https://community.smartsheet.com/discussion/65349/formula-countif-children-with-multiple-condi-
tions

https://community.smartsheet.com/discussion/111318/count-if-children-rows-are-completed

© Hans Porzel, 10/2025 | CAPM® (PMI), PSM I® (Scrum.org), Smartsheet Prod. Cert® 2020 Page 106 / 209 pages