Need a formula where the children rows = the parent rows

swaldon2

I need a formula that makes all the rows under PPA say "PPA" in the same column. I need the parent row name to basically fill in all the children row names all within the same column.

bisaacs

Hey @swaldon2,

In the child rows, you could use =PARENT() and drag/drop that down the column in every child row and it should copy the parent row data.

Hope this helps!

swaldon2

@bisaacs Is there a way to do that as a column formula? Dragging and dropping the formula leads to user error and I am trying to avoid that.

bisaacs

Hey @swaldon2,

Unfortunately column formulas currently don't allow for user data input. If you make a formula a column formula, it applies to all rows in the column, and you won't be able to enter data.