Indent Level Summations for Quotation Sheets

Hello,

I am trying to find a suitable formula so that my Total Hours indent level 0 row can sum all underlying indent level 1 Total Hours column values and stop the sum at the next indent level 0 row.

Is this possible?

Answers

  • Matt Johnson
    Matt Johnson ✭✭✭✭✭✭

    Hi @Mathieu Kotnjek

    I usually do =SUM(CHILDREN()) in the Total Hours parent row and then lock that row. It's not a perfect solution because you have to set it up each time you add a new parent row but its simple and easy to understand for others to use on their sheets. There's probably other ways too.

    I hope that helps.

    Matt Johnson

    Sevan Technology

    Smartsheet Aligned Partner

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!