SUMIFs with Children in a specific criteria

Hi SS Community,

Hope everyone is staying safe in the current way of living.

I'm looking towards you for help with what seems a fairly simple problem. I want to calculate the allocation % of a Project Manager, for projects that are "Current". The Projects are set up as children under the project manager name. Please see the following screen shot for clarity. i've combed through the community feed on similar issues and have tried a few suggestions but none of them have worked so far.

What am I missing?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!