All boxes are checked when converting "=IF(COUNTIF(CHILDREN(), 0) > 0, 0, 1)" to column formula
I have a project with parent and child rows with Check Box. I'm trying to use formula =IF(COUNTIF(CHILDREN(), 0) > 0, 0, 1) so that when children are checked parent row is checked.
This formula works fine in individual parent cell but when I convert it to column formula all check boxed are checked.
Please advice @Paul Newcome. Thank you.