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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!