SUMIF Children

cbadaracco

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.

Frank S.

@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 S.

@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.

cbadaracco

Thank you Frank! It worked.