Counting Grandchildren Rows based on multiple criteria
Hello, I am trying to count grandchildren rows based on 2 column criteria. My parent row is different task orders and underneath are multiple children(Hospitals) and the children all each have children too (quarters). For each quarter, I need to count the number of grandchildren in that quarter that have a date in my "Date Received" Column.
So my column titles are "task orders" and "Date Received". and my hierarchy looks like this:
Parent: Task Order
Grandchildren1: quarter 1
Grandchildren2: quarter 2.
So I want to know the number of Grandchildren in quarter 2 that have a received date. Any help would be great!
Help Article Resources
Check out the Formula Handbook template!