INDEX multiple CHILDREN values in PARENTrow

Alexandre Couillard

Hi,

I would like to index multiple children in a parent row. I'm using this formula if there is 3 children :

="•" + INDEX(CHILDREN([Primary Column]@row), 1) + $[Column3]$1 + INDEX(CHILDREN([Primary Column]@row), 2) + $[Column3]$1 + INDEX(CHILDREN([Primary Column]@row), 3)

I'm using this formula if there is 2 children :

="•" + INDEX(CHILDREN([Primary Column]@row), 1) + $[Column3]$1 + INDEX(CHILDREN([Primary Column]@row), 2)

Is it possible to make sure that the formula count the number of children and return the correct values in the parent row instead of adding up all index?

Thank you

L_123

=join(children([primary column]@row),char(10)+"•")

That should do it.