I am looking for a formula to collapse the sub-task rows into the parent after all sub-tasks are completed. I found a formula that will check mark the parent row after all sub-tasks are checked complete, but want to collapse when that occurs. I would like to add that onto this formula:
=IF(COUNT(CHILDREN()) = (COUNTIF(CHILDREN(), 1)), 1, 0)