SUMIF Children

I am building out my project plan. I need to track % complete per project phase. How do I add up the % complete of the children in each phase? I could use help with the formula.

Best Answer

  • Frank S.
    Frank S. ✭✭✭✭✭✭
    Answer ✓

    @cbadaracco

    You have a few options on how to get the results you are looking for:

    Option #1: If you use one of the Smrtsheet Project templates, this value will be calculated automatically.

    Option #2: You can use the following formula:

    IFERROR(AVG(COLLECT(CHILDREN(), CHILDREN(Status@row), "Complete")), 0)

    I hope this helps.

    Frank Smith, PMP

    Assistant Director | IT Special Projects Mgr.

    Oregon Parks & Recreation Department

    If my response helps, please mark it as an accepted answer. 😎

Answers

  • Frank S.
    Frank S. ✭✭✭✭✭✭
    Answer ✓

    @cbadaracco

    You have a few options on how to get the results you are looking for:

    Option #1: If you use one of the Smrtsheet Project templates, this value will be calculated automatically.

    Option #2: You can use the following formula:

    IFERROR(AVG(COLLECT(CHILDREN(), CHILDREN(Status@row), "Complete")), 0)

    I hope this helps.

    Frank Smith, PMP

    Assistant Director | IT Special Projects Mgr.

    Oregon Parks & Recreation Department

    If my response helps, please mark it as an accepted answer. 😎

  • Thank you Frank! It worked.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!