How to use =SUM(CHILDREN()) for all PARENT in the same column ?

Grégoire Cadet

Hello i would like to know how i can SUM a budget in the first row of PARENT regarding their CHILDREN.

And then make it a column formula but for just the PARENT rows.

Grégoire Cadet

To be more precise..

Andrée Starå

Hi @Grégoire Cadet

I hope you're well and safe!

If I understand your question correctly, unfortunately, it's not possible because you can't combine manual values and a formula in a Column Formula, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment.

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!

Grégoire Cadet

Hello @Andrée Starå,

Thank you for your answer.

I think it is a good idea too ;)

Then i must do it in two different column.

Best regards,

GC

Andrée Starå

@Grégoire Cadet

Excellent!

Happy to help!

Yes, it has to be in another column.

✅Remember! 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!