Absolute reference for parent cell

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!
Answers
-
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.
Thank you,
Kevin
Happy to help if I can.
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer)
Help Article Resources
Categories
Check out the Formula Handbook template!