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
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!