Parent Copy from Grandparent row. Child Copy from Parent Row

Emi

Hello Smartsheet community,

Is there the fastest way to have the parent row copy from the Grandparent row and child row copy from the parent row? Instead of =[Colimn2]1 for each cell.

Thank you

Kelly Moore

Hey @Emi

An example of what you're wanting to achieve might be useful. If a Grandparent row is copied into a Parent row (which is actually the Parent to that Parent row), and the Parent is copied to the Child, are you asking for the Grandparent row to be copied to all rows?

If you want each Parent group to show that Parent, try this. This formula would go into the column where you want the value populated

=IF(COUNT(CHILDREN([your primary column]@row))>0, [your desired column]@row, PARENT())

If you would like every row to carry the value of the Grandparent

=IF(Level@row = 0, [your desired column]@row, INDEX(COLLECT([your desired column]:[your desired column], Level:Level, 0), 1))

Be sure to edit the above formulas to insert your actual column names into the formula

If these don't answer your question, please share a screenshot (no sensitive info) or a mock up, and I'll be happy to provide more details.

Kelly

Kelly Moore

Hey @Emi

An example of what you're wanting to achieve might be useful. If a Grandparent row is copied into a Parent row (which is actually the Parent to that Parent row), and the Parent is copied to the Child, are you asking for the Grandparent row to be copied to all rows?

If you want each Parent group to show that Parent, try this. This formula would go into the column where you want the value populated

=IF(COUNT(CHILDREN([your primary column]@row))>0, [your desired column]@row, PARENT())

If you would like every row to carry the value of the Grandparent

=IF(Level@row = 0, [your desired column]@row, INDEX(COLLECT([your desired column]:[your desired column], Level:Level, 0), 1))

Be sure to edit the above formulas to insert your actual column names into the formula

If these don't answer your question, please share a screenshot (no sensitive info) or a mock up, and I'll be happy to provide more details.

Kelly

Emi

Hello Kelly,

It works for me.

Thank you so much for your help :)