% Complete of children row so parent row is 100% of children

BESP10
BESP10 ✭✭✭✭✭✭

Good afternoon, we have a Parent Row that is the sum of the children, in the column next to it we need to give each row a % value based on that rows % of the total in the parent row. How do we keep the parent row constant because when we copy the formula down it reads the next row down


Best Answer

  • BESP10
    BESP10 ✭✭✭✭✭✭
    Answer ✓

    Thank you @Bassam Khalil , that worked, is there a way to do a formula so it always goes to the parent row? When we add multiple scope items with parent and child rows on the same sheet we were hoping we could collapse the rows and copy the formula in the parent row


    Thanks

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!