COUNT (CHILDREN()) = counts zero

Joerg Schmidt

Hi,

counting works perfectly in the rows above - is there a way to repair the sheet and the formula?

Paul Newcome

When you remove the hierarchy, they are no longer considered Child Rows vs Parent Rows which means that the hierarchy based functions such as CHILDREN will no longer work as intended. You would need to either specify your range

[Column Name]12:[Column Name]32

Or use a helper column to designate not only which rows should be considered a child row but also which row they are a child of. Then you would need to adjust your formulas to evaluate this new column in place of the CHILDREN function.

Paul Newcome

You don't have any children rows indented underneath of "Neue Vorgange".

Joerg Schmidt

thank you for teaching me a new word = indent ;-) - I had to look it up ;-))

No, all child rows are in the same position as the "mother row" - as shown in the screenshot above.

But I had to delete child rows several times because if I ad a new row by filling out the Smartsheet form

there is always a gap between the old and the new row (about 8-10 rows in between)

strange - isn´t it ?

Andrée Starå

https://help.smartsheet.com/function/children

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

Paul Newcome

When you remove the hierarchy, they are no longer considered Child Rows vs Parent Rows which means that the hierarchy based functions such as CHILDREN will no longer work as intended. You would need to either specify your range

[Column Name]12:[Column Name]32

Or use a helper column to designate not only which rows should be considered a child row but also which row they are a child of. Then you would need to adjust your formulas to evaluate this new column in place of the CHILDREN function.