Spreadsheet: 884939d1734337746-table-formula-help-to-remove-0-in-columns-and-to-remove-00-01-1900-in-date-columns-dashboard-help
Sheet: query (6)

Status | WP ID | Work Package Name | Work Package Owner | Project Manager | Work Package Support | Dependency on another project | Start Date | Baseline End Date | Current End Date
Pipeline | 1 | test 1 | [NAME] |  | Boland [NAME] | No
Pipeline | 2 | test 2 |  |  |  | No
Live | 3 | test 3 | Smith Louise | Smith Louise | Boland [NAME] | No
Live | 4 | test 4 | WEBER Vincent | Parsons Gavin |  | No | 2024-12-02 00:00:00 | 2025-03-28 00:00:00
Live | 5 | test 5 | WEBER Vincent | Parsons Gavin |  | No | 2024-12-02 00:00:00 | 2025-04-30 00:00:00
Live | 6 | test 6 | [NAME] |  | Boland [NAME] | No | 2024-12-02 00:00:00 | 2025-01-31 00:00:00
Live | 7 | test 7 | [NAME] | Parsons Gavin | Boland [NAME] | No | 2025-05-01 00:00:00 | 2025-10-31 00:00:00
Live | 8 | test 8 | [NAME] |  | Boland [NAME] | No | 2024-12-02 00:00:00 | 2025-01-31 00:00:00
Pipeline | 9 | test 9 | [NAME] | Parsons Gavin |  | No | 2024-12-02 00:00:00 | 2025-01-31 00:00:00
Live | 10 | test 10 | Smith Louise | Smith Louise | Boland [NAME] | No
Live | 11 | test 11 | [NAME] |  | Boland [NAME] | No | 2024-12-02 00:00:00 | 2025-01-31 00:00:00
On-Hold | 12 | test 12 |  |  |  | No
Live | 13 | test 13 | [NAME] | Smith Louise | Boland [NAME] | No | 2024-12-02 00:00:00 | 2025-06-27 00:00:00
Live | 14 | test 14 | [NAME] |  | Boland [NAME] | No | 2024-12-02 00:00:00 | 2024-12-31 00:00:00
Live | 15 | test 15 | [NAME] | Smith Louise | Boland [NAME] | No | 2024-12-02 00:00:00 | 2026-01-01 00:00:00
Live | 16 | test 16 | [NAME] |  | Boland [NAME] | No | 2025-06-02 00:00:00 | 2025-06-30 00:00:00
Live | 17 | test 17 | [NAME] |  | Boland [NAME] | No | 2024-12-02 00:00:00 | 2025-06-30 00:00:00
Pipeline | 18 | test 18 | [NAME] |  | Boland [NAME] | No
Pipeline | 19 | test 19 |  |  |  | No
Live | 20 | test 20 | [NAME] |  | Boland [NAME] | No
Live | 21 | test 21 | [NAME] | Smith Louise | Boland [NAME] | No | 2024-12-02 00:00:00 | 2025-12-31 00:00:00
Live | 22 | test 22 |  |  |  | No | 2024-12-02 00:00:00 | 2025-01-31 00:00:00
Live | 23 | test 23 | [NAME] |  | Boland [NAME] | No | 2024-12-02 00:00:00 | 2025-02-28 00:00:00
Live | 24 | test 24 | WEBER Vincent | Parsons Gavin |  | No | 2025-04-01 00:00:00 | 2025-05-30 00:00:00
Live | 25 | test 25 | [NAME] |  | Boland [NAME] | Yes | 2025-04-01 00:00:00 | 2025-07-31 00:00:00
Live | 26 | test 26 | Smith Louise | Smith Louise | Boland [NAME] | No
Live | 27 | test 27 | [NAME] |  | Boland [NAME] | No | 2025-03-02 00:00:00 | 2025-10-31 00:00:00
Pipeline | 28 | test 28 | [NAME] | [NAME] |  | No | 2025-03-03 00:00:00 | 2025-12-31 00:00:00
Pipeline | 29 | test 29 |  |  |  | No
Live | 30 | test 30 | [NAME] | [NAME] |  | No
Live | 31 | test 31 | [NAME] |  |  | No
Live | 32 | test 32 | [NAME] |  | Boland [NAME] | No | 2024-12-02 00:00:00 | 2025-03-28 00:00:00
Live | 33 | test 33 | [NAME] |  | Boland [NAME] | No | 2024-12-02 00:00:00 | 2025-01-31 00:00:00
Live | 34 | test 34 | [NAME] | Smith Louise |  | Yes | 2024-12-02 00:00:00 | 2025-12-31 00:00:00
Pipeline | 35 | test 35 | [NAME] | Parsons Gavin |  | No | 2024-12-02 00:00:00 | 2024-12-27 00:00:00
Live | 36 | test 36 | [NAME] | Parsons Gavin |  | No | 2025-04-01 00:00:00 | 2025-12-31 00:00:00