Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Using a Child cell as a constant in the Grandchildren cell formula
So I have a Parent row, Children row, and Grandchildren under the Children row/cell.
On the Grandchildren row I want to take the Child cell divide it by the Parent cell and then multiply it by a cell on the grandchild row. I think I have a good formula - if I just can figure out what to call or how to indicate the Parent and Child cells.
I want to use the Children row/cell as a constant in a formula on the Grandchild row/cell. I have a formula that I think will work but I don't know what to call the Children row/cell.
=([Column A]ChildrenCell/[Column A]ParentCell)*ColumnC
I know to make a cell constant I would use $ in front of the row number. But since the row number may change depending on how many Children I have, I think there must be a way to indicate going to the Child for the Grandchildren.
Help please Thanks!
Comments
-
-
Thanks!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 464 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives