Automatically check-mark parent row when all children rows have been check-mark

Jonathan Chan

In below scenrio, is there a formula or some approach that will enable new added rows to be automatically accounted by formulations on outdent rows?  The purpose is to automatically checkmark the parent/outdent rows when all their children/indent rows have been checkmarked. 

 

Pls refer to attached picture “Query - Checkmark row” for picture-supported explanation:
• "=3" variable inside formulation of row 7’s cell automatically update itself to account for an indent row inserted (ex. row 14) with new info.

 

Thank you.

 

Jon

Jonathan Chan

The answer is:

=IF(COUNTIF(CHILDREN(), 1) = COUNT(CHILDREN()), 1, 0)

 

The below question thread also points to the answer:

 

https://www.smartsheet.com/blog/support-tip-checkbox-formula