Sum of expenses of child rows in a formula row

Shadaab
Shadaab ✭✭
in Formulas and Functions

Hi

I have a sheet wherein a column contains all the expenses that is basically generated from the sum of other cells in the same row.


This row is indented and I wanted to know if I could have the total of this in the parent of this row. Like the way it could be done in a pivot table.


The formula in the column is applied as a column formula and I'm unable to put a unique formula for the other parent rows. Is there any way I could do this?


Thank you

Tags:
· Share on FacebookShare on Twitter

Best Answer

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    Answer ✓

    Hi @Shadaab

    I hope you're well and safe!

    You'd need to modify the formula to check if it's a parent row or similar, so different formulas are run depending on what it is.

    Try something like this, and then add your other formula after.

    =IF(COUNT(CHILDREN(ColumnName@row)) > 0, SUM(CHILDREN()))

    Did that work/help?

    I hope that helps!

    Be safe and have a fantastic week!

    Best,

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    ✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

    · Share on FacebookShare on Twitter

Answers

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!