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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!