Absolute reference for parent cell
![GabyC](https://us.v-cdn.net/6031209/uploads/defaultavatar/nWRMFRX6I99I6.jpg)
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
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 437 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!