Indexing Help with Children rows.
I have a sheet that is using parent and children rows. I want the parent cell to always show the value of the top most row in its child section . The formula I am using is =Index([Sample]31,1,1) . When I add a new row to this section the formula changes to =index([sample]32,1,1). I need the reference row to remain 31. I have tried to add $ in front of it and this did nothing. Any Ideas.
Help Article Resources
Check out the Formula Handbook template!