% Completed on a Project and excluding some tasks

Is there a way to calculate the percentage completed on a series of tasks yet strike out and leave some tasks that will not be worked on but need to leave there for reference. We just want to make sure that it is not counted as part of the calculation of the project % completed. Example:
Best Answer
-
Hi,
If your percentage completion column is part of project setting, I think the only option is to make the striked out tasks to 100% as well.
If it's not part of project setting, you can use the below formula to your parent row to make it work. The striked out tasks should be empty instead of 0%.
=AVG(CHILDREN())
Answers
-
Hi,
If your percentage completion column is part of project setting, I think the only option is to make the striked out tasks to 100% as well.
If it's not part of project setting, you can use the below formula to your parent row to make it work. The striked out tasks should be empty instead of 0%.
=AVG(CHILDREN())
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 486 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 498 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!