Formula TO NOT have to manully enter formula for every row

BESP10 ✭✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

Good morning, 

Looking for some help on this issue. 

We have a sheet with hundreds of rows that tally up to a total (1049.86 hours per below JPEG)

We need to calculate the % each piece is from the total . These are the children rows.

The first formula I got to work by using =SUM([Total Hours Per Peice]42 / ([Total Hours Per Peice]41))

How do I get all the children rows to reference the parent row without having to manually change the formula in every row?


Thank you 



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!