I'm completely stuck on this one and not even sure it is possible. I am trying to compile data from a sheet to be used in a dashboard to show total time to complete "phases" of a project.
I need a formula that is able to determine "Active" clients and the "Phase" that they are in, and then the processing time for that phase. Because I have Parent/Children, I am not sure how to create this formula to meet all the criteria.
Status = Active
Phase = Discovery
Total Time to Complete = Number is corresponding children row under Firm Name
I have attached a screen shot of the sheet for reference.
Any help is greatly appreciated!
Help Article Resources
Check out the Formula Handbook template!