Updating parent row with data from all children rows

Options

I am trying to update a parent row with the data found in the children rows

The following formula works

=[Check Number]2 + "," + [Check Number]3

however, I have some parent rows that have more than 2 children beneath them

Is there a formula to use the parent/child relationship to get it to include all data from the children regardless of how many there are?

Best Answers

  • Jon Mark H
    Jon Mark H ✭✭✭✭✭
    Answer ✓
    Options

    Hey @Becky Wilson !

    Are you using this formula in the parent row for [Check Number]?

    I recommend using this formula:

    =IF(COUNT(CHILDREN([Check Number]@row)) > 0, JOIN(DESCENDANTS([Check Number]@row), ","), "")


    It double checks that you have children of that row, and eliminates errors if you do NOT have children there. If you DO have children, it will put them in the parent cell w/ "," separating each of them.


    Let me know if that fixes you issue and if you have any other problems you need solved!


    -Jon Mark

  • Becky Wilson
    Becky Wilson ✭✭✭✭✭
    Answer ✓
    Options

    Thanks Jon! That worked.

Answers

  • Jon Mark H
    Jon Mark H ✭✭✭✭✭
    Answer ✓
    Options

    Hey @Becky Wilson !

    Are you using this formula in the parent row for [Check Number]?

    I recommend using this formula:

    =IF(COUNT(CHILDREN([Check Number]@row)) > 0, JOIN(DESCENDANTS([Check Number]@row), ","), "")


    It double checks that you have children of that row, and eliminates errors if you do NOT have children there. If you DO have children, it will put them in the parent cell w/ "," separating each of them.


    Let me know if that fixes you issue and if you have any other problems you need solved!


    -Jon Mark

  • Becky Wilson
    Becky Wilson ✭✭✭✭✭
    Answer ✓
    Options

    Thanks Jon! That worked.

  • Jon Mark H
    Jon Mark H ✭✭✭✭✭
    Options

    You're very welcome! Glad it helped!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!