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.