Parent roll up

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
Best Answer
-
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))
Answers
-
Are you able to provide a screenshot with mocked up data that shows what you are trying to accomplish?
-
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.
-
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 Thank you so much! I'm so happy.
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 152 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!