How to Apply Forumla to All Parent Rows and Another to All Child Rows?

Ann Foley

Hi,

I have one formula that I need applied to all of my parent rows (in this case, property name) and another formula applied to all of my children rows (the score corresponding to each month). How can I automatically apply these formulas to all parent rows and all child rows without having to copy and paste (because I have hundreds of properties)?

Thanks!

Andrée Starå

Hi Ann,

What are the formulas?

We could structure a solutions so you could use one formula that would check if it’s a parent or child and use the correct formula.

Make sense?

Would that work?

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer. It will make it easier for others to find a solution or help to answer!

Ann Foley

Hi Andrée,

My parent formula is =SUM(CHILDREN()) / COUNTIFS(CHILDREN(), NOT(ISBLANK(@cell)))

My Child formula is =INDEX({Jan GSS ITR}, MATCH(Marsha@row, {Jan GSS MARSHA}, 0))

That would be great if there was a forumula that could determine parent vs child and then apply the above formulas!

thanks

Andrée Starå

Happy to help!

Try to start your formula with something like.

=IF(COUNT(CHILDREN(Primary@row)) > 0, your formula for parent, your formula for children

Make sense?

Did it work?

Ann Foley

Hm, that didn't work. I copied that forumla and then added my parent forumla and children formula but got an error. Any suggestions?

Andrée Starå

Ok.

Can you maybe share the sheet(s)/copies of the sheet(s)? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)