Absolute reference for parent cell

GabyC

Hello,

I want to write a formula to copy over the parent row name to the whole column of the group of cells.

When I start a new project within the sheet, I want the column to change to what the project name is. Below is a snip of what I would like the formula to do. Thanks!

Kevin Smith

Hi

The easiest way to do this is to use a Summary field. Below was the summary field of the project name, and the formula in Col2 is =[Project Name]#

However, if you want to use the parent, the IsParent col has the formula of =IF(PARENT([Primary Column]@row) = "", 1, 0). This could be used creatively to get what you need if the Primary Col. will only have 1 row that has no Parents. If that is true and you want to use that method, let me know and I can play with a way to do that unless someone else has that done already.