Your schedule should show a % complete value in the Task % column, for summary tasks where all subtasks are milestones and not all are 100% complete. You can now hide all the 4 helper columns and the default % complete column.
This makes the Gantt chart more informative. This field will show the same value as the default Microsoft Project % complete and will also show % complete for summary tasks where all subtasks are milestones and this includes nested summariesĮnter the formula, IIf ( And = 1, Format ( /, "Percent"), & "%") Another useful customization techniques is to add text to the bars.
The purpose of this field is to count the number of subtasks that milestones and are 100% completeĮnter the formula, IIf ( And = 100, 1, 0)Īdd a custom field using Text1 or any other Text field and rename it “ Task %”. You can select an option to display the Critical tasks in a plan, if you do this they will typically display as red bars. So if formula result is 1, then all subtasks are milestones but if 0, not all subtasks are milestonesĮnter the formula, IIf (, / ,0)įor “calculation for task and group summary rows”, tick use formulaĪdd a custom field using Number4 or any other Number field and rename it “ Completed Milestones”. The purpose of this field is check if all subtasks are milestones. The purpose of this field is to count the total number of subtasksĮnter the formula, IIf (Not, 1, 0)Īdd a custom field using Number3 or any other Number field and rename it “ All Subtasks are Milestones”. The purpose of this field is to count the number of subtasks that are milestonesĮnter the formula, IIf (, 1, 0)įor “calculation for task and group summary rows”, tick rollup and select Sum from the dropdownĪdd a custom field using Number2 or any other Number field and rename it “ No of Subtasks”. Add a custom field using Number1 or any other Number field and rename it “ No of Milestones”.
0 kommentar(er)
