Getting value from parent row

Michael Culley

I'm trying to create a formula that will input the same value from the parent row. I'm not looking for simple =PARENT as that will just show the parent name. I want to input data into the parent row, and I want the children to have the same value for each of those columns. So if I move a row from one parent to another, it will change to the new data.

Andrée Starå

Hi Michael,

You’d use =PARENT but with the column name.

Something like.

=PARENT(ColumnName@row)

Would that work?

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi Michael,

You’d use =PARENT but with the column name.

Something like.

=PARENT(ColumnName@row)

Would that work?

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer. It will make it easier for others to find a solution or help to answer!

Michael Culley

Perfect. That was too easy.

Andrée Starå

Everything is easy when you know how to do it! 😉 

Happy to help! 

✅Remember! Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer. It will make it easier for others to find a solution or help to answer!

Krunal

Hi Andrée Starå,

I have used =PARENT(ColumnName@row) in my sheet to get the data from Parent cell to Child. Now I want to the formula to be converted to Column formula, so any new data added in the sheet has the Child cell formula in it.

See attached:

Thanks in advance

Krunal