Spreadsheet: 834071d1687429986-multi-input-conditional-formatting-copy-of-dashboard
Sheet: COPY

[NAME] (include avbl and WIP)
Add filter to organmise priority
conditional formatting for VS and ass |  |  |  |  |  |  |  |  |  |  |  |  |  | B30 Operational Dashboard Availability Summary
days for actions - remaining - change to at risk? |  |  |  |  |  |  |  |  |  |  |  |  |  | Name  - copy formattiing and layout
closed actions back to green
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | Priority |  |  |  |  | Assets
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  | 3 |  |  |  |  |  |  |  |  |  |  | 4 |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B |  |  |  |  |  |  |  |  |  | 3 |  |  |  |  | 11 |  |  |  |  |  |  |  |  |  | 22 |  |  |  |  |  |  |  |  |  | 33 |  |  |  |  |  |  |  |  |  |  | 4 |  |  |  |  |  |  |  |  |  | 55
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C |  |  |  |  |  |  |  |  |  | 4 |  |  |  |  | 6 |  |  |  |  | 3 |  |  |  |  | 7 |  |  |  |  |  |  |  |  |  | 8 |  |  |  |  | 5 |  |  |  |  |  | 9 |  |  |  |  |  |  |  |  |  | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WIP |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WIP
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  | 12 |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  | 4 |  |  |  |  | 13 |  |  |  |  | 0 |  |  |  |  |  | 14 |  |  |  |  | 2 |  |  |  |  | 15 |  |  |  |  |  |  |  |  |  | 16 |  |  |  |  |  |  |  |  |  | 17
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WIP |  |  |  |  |  |  |  |  |  | WIP |  |  |  |  |  |  |  |  |  |  | WIP
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E |  |  |  |  |  |  |  |  |  | 5 |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  | 3 |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | F |  |  |  |  |  |  |  |  |  | 5 |  |  |  |  | 1 |  |  |  |  | 5 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 3 |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | did tha |  |  |  |  |  |  |  |  |  | AVBL |  |  |  |  |  |  |  |  |  | AVBL |  |  |  |  |  |  |  |  |  | AVBL
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Date |  |  |  |  | [NAME] |  |  |  |  |  |  | Asset |  |  |  |  |  |  | Operational Status |  |  |  | Description |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Owner |  |  |  | Original Target Date |  |  |  |  | Status |  |  |  |  |  | Revised Target Date |  |  |  |  | Comments
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-06-21 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OOS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Overdue
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Operable with defect |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Complete
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Operable