Need % Complete rollup to exclude tasks not needed in overall calculation of % done
I have a master project plan where all tasks are listed. I want to use this plan for any project and if a tasks is not needed I would like to keep the row but have a status of N/A. I would then like to have the % complete formula for the hierarchy to only calculate those rows that are needed so the overall % completion is not skewed with tasks that will never be used.
I have tried many formulas and not sure which one would make sense - I also have not been able to accurately get any of the formulas I tried to create to even work. IF(AND? AVG(CHILDREN? SUMIF?
On thing to note is that I took off the project dependencies because that was not leaving out those tasks that would not be used. Not sure if that can be used or not.
Help Article Resources
Check out the Formula Handbook template!