Parent roll up

Ess

Hello everyone.

Can someone kindly help me with the formula for rolling up %Progress column to the parent row based on end date.

I want to know what is the %Progress of a parent row based on end date example. 2020.12.31

Paul Newcome

You would use something along the lines of...

=AVG(COLLECT(CHILDREN(), CHILDREN([Start Date]@row), @cell >= DATE(2020, 07, 01), CHILDREN([End Date]@row), @cell <= DATE(2020, 12, 31))

Paul Newcome

Are you able to provide a screenshot with mocked up data that shows what you are trying to accomplish?

Ess

@Paul Newcome

I'm trying to get the %Progress AVG of children based on a specific Start Date and End Date.

Lets say I want to know the %progress of different Workstreams based on dates of the deliverables.

Example AVG of all deliverables whose Start date is 2020,7,01 end dates is <= 2020,12,31 this formula should be on the parent row Workstream.

I hope this makes more sense.

Paul Newcome

You would use something along the lines of...

=AVG(COLLECT(CHILDREN(), CHILDREN([Start Date]@row), @cell >= DATE(2020, 07, 01), CHILDREN([End Date]@row), @cell <= DATE(2020, 12, 31))

Ess

@Paul Newcome Thank you so much! I'm so happy.

Paul Newcome

Happy to help. 👍️