Spreadsheet: 865685d1712711691-conditional-formatting-task-tracking-formula-assistance
Sheet: GanttChart

New Fixed Line Project Schedule
 | Project Start Date | 2024-04-10 00:00:00 |  |  |  | Display Week | 1
 | Project Lead
WBS | TASK | LEAD | PREDECESSOR | START | END | DAYS | % DONE | WORK DAYS
 | Facility Handover
 | [NAME] |  |  | 2024-04-10 00:00:00 |  | 7 | 0.25
 | Communicate Requirements |  |  | 2024-04-17 00:00:00 |  | 7 | 0
 | [Task] |  |  | 2024-04-17 00:00:00 |  | 4 | 0
 | [Task] |  |  | 2024-04-17 00:00:00 |  | 4 | 0
 | [Sub-task] |  |  | 2024-04-17 00:00:00 |  | 2 | 0
 | [Sub-task] |  |  | 2024-04-17 00:00:00 |  | 3 | 0
 | [Task] |  |  | 2024-04-17 00:00:00 |  | 5 | 0
 | [Task] |  |  | 2024-04-17 00:00:00 |  | 7 | 0
 | [Task] |  |  | 2024-04-17 00:00:00 |  | 7 | 0
 | Return to Operation
 | [Task] |  |  | 2018-02-10 00:00:00 |  | 4 | 0
 | [Task] |  |  | 2018-02-14 00:00:00 |  | 3 | 0
 | [Task] |  |  | 2018-02-14 00:00:00 |  | 3 | 0
 | [Task] |  |  | 2018-02-17 00:00:00 |  | 6 | 0
 | [Task] |  |  | 2018-02-23 00:00:00 |  | 3 | 0
 | Air Quencher Operation
 | Investigate Slippage |  |  | 2024-04-24 00:00:00 |  | 14 | 0
 | Remmedy as required |  |  | 2024-05-08 00:00:00 |  | 14 | 0
 | Auto Start requirements |  |  | 2024-04-24 00:00:00 |  | 14 | 0
 | Implement Upgrade |  |  | 2024-05-08 00:00:00 |  | 14 | 0
 | [Task] |  |  | 2018-02-23 00:00:00 |  | 3 | 0
 | Lighting
 | Underfoot Grinding 1000 Lumen install |  |  | 2024-05-06 00:00:00 |  | 7 | 0
 | Welder Lighting Install |  |  | 2024-05-06 00:00:00 |  | 21 | 0
 | [Task] |  |  | 2018-01-31 00:00:00 |  | 1 | 0
 | [Task] |  |  | 2018-02-01 00:00:00 |  | 1 | 0
 | [Task] |  |  | 2018-02-02 00:00:00 |  | 1 | 0
 | Facility Doors
 | Scope & quote change door position |  |  | 2018-01-29 00:00:00 |  | 1 | 1
 | Submit request to Site Infrastructure |  |  | 2018-01-30 00:00:00 |  | 1 | 0
 | Scope & Quote Viewing Window Install |  |  | 2018-01-31 00:00:00 |  | 1 | 1
 | Submit request to Site Infrastructure |  |  | 2018-02-01 00:00:00 |  | 1 | 0
 | Execute Door Change & Window Install |  |  | 2018-02-02 00:00:00 |  | 1 | 0
 | Underfoot Grinding Stairs
 | Engineering Scope for Required Changes |  |  | 2024-04-01 00:00:00 |  | 30 | 0.5
 | Review & Scope Engineering Changes |  |  | 2024-05-01 00:00:00 |  | 7 | 0
 | Execute Engineering Changes to [NAME] |  |  | 2024-05-08 00:00:00 |  | 14 | 0
 | [Task] |  |  | 2018-02-01 00:00:00 |  | 1 | 0
 | [Task] |  |  | 2018-02-02 00:00:00 |  | 1 | 0
 | Insulated Rollers
 | [Task] |  |  | 2018-01-29 00:00:00 |  | 1 | 0
 | [Task] |  |  | 2018-01-30 00:00:00 |  | 1 | 0
 | [Task] |  |  | 2018-01-31 00:00:00 |  | 1 | 0
 | [Task] |  |  | 2018-02-01 00:00:00 |  | 1 | 0
 | [Task] |  |  | 2018-02-02 00:00:00 |  | 1 | 0
 | [NAME]
 | [Task] |  |  | 2018-01-29 00:00:00 |  | 1 | 0
 | [Task] |  |  | 2018-01-30 00:00:00 |  | 1 | 0
 | [Task] |  |  | 2018-01-31 00:00:00 |  | 1 | 0
 | [Task] |  |  | 2018-02-01 00:00:00 |  | 1 | 0
 | [Task] |  |  | 2018-02-02 00:00:00 |  | 1 | 0
 | Interlocks
 | [Task] |  |  | 2018-01-29 00:00:00 |  | 1 | 0
 | [Task] |  |  | 2018-01-30 00:00:00 |  | 1 | 0
 | [Task] |  |  | 2018-01-31 00:00:00 |  | 1 | 0
 | [Task] |  |  | 2018-02-01 00:00:00 |  | 1 | 0
 | [Task] |  |  | 2018-02-02 00:00:00 |  | 1 | 0
 | [NAME]
 | [Task] |  |  | 2018-01-29 00:00:00 |  | 1 | 0
 | [Task] |  |  | 2018-01-30 00:00:00 |  | 1 | 0
 | [Task] |  |  | 2018-01-31 00:00:00 |  | 1 | 0
 | [Task] |  |  | 2018-02-01 00:00:00 |  | 1 | 0
 | [Task] |  |  | 2018-02-02 00:00:00 |  | 1 | 0
 | [NAME]
 | [Task] |  |  | 2018-01-29 00:00:00 |  | 1 | 0
 | [Task] |  |  | 2018-01-30 00:00:00 |  | 1 | 0
 | [Task] |  |  | 2018-01-31 00:00:00 |  | 1 | 0
 | [Task] |  |  | 2018-02-01 00:00:00 |  | 1 | 0
 | [Task] |  |  | 2018-02-02 00:00:00 |  | 1 | 0
 | [NAME]
 | [Task] |  |  | 2018-01-29 00:00:00 |  | 1 | 0
 | [Task] |  |  | 2018-01-30 00:00:00 |  | 1 | 0
 | [Task] |  |  | 2018-01-31 00:00:00 |  | 1 | 0
 | [Task] |  |  | 2018-02-01 00:00:00 |  | 1 | 0
 | [Task] |  |  | 2018-02-02 00:00:00 |  | 1 | 0
 | Access Gates
 | [Task] |  |  | 2018-01-29 00:00:00 |  | 1 | 0
 | [Task] |  |  | 2018-01-30 00:00:00 |  | 1 | 0
 | [Task] |  |  | 2018-01-31 00:00:00 |  | 1 | 0
 | [Task] |  |  | 2018-02-01 00:00:00 |  | 1 | 0
 | [Task] |  |  | 2018-02-02 00:00:00 |  | 1 | 0
 | (Insert Task)
 | [Task] |  |  | 2018-01-29 00:00:00 |  | 1 | 0
 | [Task] |  |  | 2018-01-30 00:00:00 |  | 1 | 0
 | [Task] |  |  | 2018-01-31 00:00:00 |  | 1 | 0
 | [Task] |  |  | 2018-02-01 00:00:00 |  | 1 | 0
 | [Task] |  |  | 2018-02-02 00:00:00 |  | 1 | 0
 | (Insert Task)
 | [Task] |  |  | 2018-01-29 00:00:00 |  | 1 | 0
 | [Task] |  |  | 2018-01-30 00:00:00 |  | 1 | 0
 | [Task] |  |  | 2018-01-31 00:00:00 |  | 1 | 0
 | [Task] |  |  | 2018-02-01 00:00:00 |  | 1 | 0
 | [Task] |  |  | 2018-02-02 00:00:00 |  | 1 | 0
TEMPLATE ROWS
See the Help worksheet to learn how to use these rows. You can hide these rows before printing.
 | [ Level 1 Task or Phase ]
 | . [ Level 2 Task ]
 | . . [ Level 3 Task ]
 | . . . [ Level 4 Task ]