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
-
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
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 406 Global Discussions
- 217 Industry Talk
- 456 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!