INDEX multiple CHILDREN values in PARENTrow

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

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!