Spreadsheet: 882736d1731166772-how-to-give-results-in-a-cell-based-on-the-difference-in-dates-with-respect-to-conditions-book1
Sheet: Sheet1

Notification | Author | Required Start | Created On | Column1 | Column2 | Column3 | Required End | Description | Task Status | Task number | Task code text | Task text | Changed By | Planned start date | Planned finish | Changed On | Time of change | DM SLA | Pack Owner | Location | Category | Sub-Category | Sub-Category2 | DM Created Year | DM Created Month | Task Created Year | Task Created Month | DM/Task Closed Year | DM/Task Closed Month | Created by Quarter | Closed by Quarter | NRFT Reason | NRFT Location | NRFT Responsible | [NAME] | Review Task SLA | QA Approval | Maintenance Extension | Review Extension
201573904 | SU711141 | 2024-11-07 00:00:00 | 2024-11-08 00:00:00 |  |  |  | 2024-11-14 00:00:00 | DM_ATTP_GSK_EU_DECOM_PARTIAL_3279E_1 | TSRL REQ | 2 | QA Approval Required to Proceed? | Approval task | SU711141 | 2024-11-08 00:00:00 | 2024-11-11 00:00:00 | 2024-11-08 00:00:00 | 05:59:21 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Blank cell
201573904 | SU711141 | 2024-11-07 00:00:00 | 2024-11-08 00:00:00 |  |  |  | 2024-11-14 00:00:00 | DM_ATTP_GSK_EU_DECOM_PARTIAL_3279E_1 | TSCO SKP | 1 | DCF Task | Data provided |  | 2024-11-07 00:00:00 | 2025-03-11 00:00:00 |  | 00:00:00
201573904 | SU711141 | 2024-11-07 00:00:00 | 2024-11-08 00:00:00 |  |  |  | 2024-11-14 00:00:00 | DM_ATTP_GSK_EU_DECOM_PARTIAL_3279E_1 | [NAME] | 3 | Maintain Master Data |  |  | 2024-11-10 00:00:00 | 2025-03-11 00:00:00 | 2024-11-12 00:00:00 | 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OOSLA |  |  | Result
201573904 | SU711141 | 2024-11-07 00:00:00 | 2024-11-08 00:00:00 |  |  |  | 2024-11-14 00:00:00 | DM_ATTP_GSK_EU_DECOM_PARTIAL_3279E_1 | TSCO REQ | 4 | Perform Independent Check |  | RH294814 | 2024-11-07 00:00:00 | 2025-03-11 00:00:00 | 2024-11-09 00:00:00 | 00:00:00
201573904 | SU711141 | 2024-11-07 00:00:00 | 2024-11-08 00:00:00 |  |  |  | 2024-11-14 00:00:00 | DM_ATTP_GSK_EU_DECOM_PARTIAL_3279E_1 | [NAME] | 5 | D2C Product Quality Critical Review |  |  | 2024-11-07 00:00:00 | 2025-03-11 00:00:00 |  | 00:00:00
201573904 | SU711141 | 2024-11-07 00:00:00 | 2024-11-08 00:00:00 |  |  |  | 2024-11-14 00:00:00 | DM_ATTP_GSK_EU_DECOM_PARTIAL_3279E_1 | [NAME] | 6 | PE Product Quality Critical Review |  |  | 2024-11-07 00:00:00 | 2025-03-11 00:00:00 |  | 00:00:00
201573904 | SU711141 | 2024-11-07 00:00:00 | 2024-11-08 00:00:00 |  |  |  | 2024-11-14 00:00:00 | DM_ATTP_GSK_EU_DECOM_PARTIAL_3279E_1 | [NAME] | 7 | WM Product Quality Critical Review |  |  | 2024-11-07 00:00:00 | 2025-03-11 00:00:00 |  | 00:00:00
201573904 | SU711141 | 2024-11-07 00:00:00 | 2024-11-08 00:00:00 |  |  |  | 2024-11-14 00:00:00 | DM_ATTP_GSK_EU_DECOM_PARTIAL_3279E_1 | [NAME] | 8 | Complete Notification & Inform Requestor |  |  | 2024-11-07 00:00:00 | 2025-03-11 00:00:00 |  | 00:00:00
201573839 | SU711141 | 2024-11-07 00:00:00 | 2024-11-08 00:00:00 |  |  |  | 2024-11-14 00:00:00 | DM_ATTP_GSK_EU_GTIN_ADD_1 | TSCO SKP | 2 | QA Approval Required to Proceed? | Approval task | SU711141 | 2024-11-07 00:00:00 | 2025-03-11 00:00:00 | 2024-11-08 00:00:00 | 04:01:18
201573839 | SU711141 | 2024-11-07 00:00:00 | 2024-11-08 00:00:00 |  |  |  | 2024-11-14 00:00:00 | DM_ATTP_GSK_EU_GTIN_ADD_1 | TSRL REQ | 3 | Maintain Master Data | 1 GTIN set up | SU711141 | 2024-11-08 00:00:00 | 2024-11-14 00:00:00 | 2024-11-10 00:00:00 | 04:01:18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | INSLA
201573839 | SU711141 | 2024-11-07 00:00:00 | 2024-11-08 00:00:00 |  |  |  | 2024-11-14 00:00:00 | DM_ATTP_GSK_EU_GTIN_ADD_1 | TSCO SKP | 5 | D2C Product Quality Critical Review | Skipped | SU711141 | 2024-11-07 00:00:00 | 2025-03-11 00:00:00 | 2024-11-08 00:00:00 | 04:01:18
201573839 | SU711141 | 2024-11-07 00:00:00 | 2024-11-08 00:00:00 |  |  |  | 2024-11-14 00:00:00 | DM_ATTP_GSK_EU_GTIN_ADD_1 | TSCO SKP | 6 | PE Product Quality Critical Review | Skipped | SU711141 | 2024-11-07 00:00:00 | 2025-03-11 00:00:00 | 2024-11-08 00:00:00 | 04:01:18
201573839 | SU711141 | 2024-11-07 00:00:00 | 2024-11-08 00:00:00 |  |  |  | 2024-11-14 00:00:00 | DM_ATTP_GSK_EU_GTIN_ADD_1 | TSCO SKP | 7 | WM Product Quality Critical Review | Skipped | SU711141 | 2024-11-07 00:00:00 | 2025-03-11 00:00:00 | 2024-11-08 00:00:00 | 04:01:18
201573839 | SU711141 | 2024-11-07 00:00:00 | 2024-11-08 00:00:00 |  |  |  | 2024-11-14 00:00:00 | DM_ATTP_GSK_EU_GTIN_ADD_1 | TSCO REQ | 1 | DCF Task | Data provided |  | 2024-11-07 00:00:00 | 2025-03-11 00:00:00 |  | 00:00:00
201573839 | SU711141 | 2024-11-07 00:00:00 | 2024-11-08 00:00:00 |  |  |  | 2024-11-14 00:00:00 | DM_ATTP_GSK_EU_GTIN_ADD_1 | [NAME] | 4 | Perform Independent Check |  |  | 2024-11-07 00:00:00 | 2025-03-11 00:00:00 |  | 00:00:00
201573839 | SU711141 | 2024-11-07 00:00:00 | 2024-11-08 00:00:00 |  |  |  | 2024-11-14 00:00:00 | DM_ATTP_GSK_EU_GTIN_ADD_1 | [NAME] | 8 | Complete Notification & Inform Requestor |  |  | 2024-11-07 00:00:00 | 2025-03-11 00:00:00 |  | 00:00:00
201573537 | PN414085 | 2024-11-05 00:00:00 | 2024-11-07 00:00:00 |  |  |  | 2024-11-12 00:00:00 | DM_ATTP_GSK_EU_GTIN_ADD_1 | TSRL REQ | 3 | Maintain Master Data | 1 GTIN maste data MOD SLT | PN414085 | 2024-11-07 00:00:00 | 2024-11-11 00:00:00 | 2024-11-08 00:00:00 | 06:13:08
201573537 | PN414085 | 2024-11-05 00:00:00 | 2024-11-07 00:00:00 |  |  |  | 2024-11-12 00:00:00 | DM_ATTP_GSK_EU_GTIN_ADD_1 | TSCO APP | 2 | QA Approval Required to Proceed? | Approval task | MMA62768 | 2024-11-07 00:00:00 | 2024-11-08 00:00:00 | 2024-11-07 00:00:00 | 12:17:58
201573537 | PN414085 | 2024-11-05 00:00:00 | 2024-11-07 00:00:00 |  |  |  | 2024-11-12 00:00:00 | DM_ATTP_GSK_EU_GTIN_ADD_1 | TSCO SKP | 1 | DCF Task | Data Provided | PN414085 | 2024-11-05 00:00:00 | 2025-03-08 00:00:00 | 2024-11-07 00:00:00 | 11:59:22
201573537 | PN414085 | 2024-11-05 00:00:00 | 2024-11-07 00:00:00 |  |  |  | 2024-11-12 00:00:00 | DM_ATTP_GSK_EU_GTIN_ADD_1 | [NAME] | 4 | Perform Independent Check |  |  | 2024-11-05 00:00:00 | 2025-03-08 00:00:00 |  | 00:00:00
201573537 | PN414085 | 2024-11-05 00:00:00 | 2024-11-07 00:00:00 |  |  |  | 2024-11-12 00:00:00 | DM_ATTP_GSK_EU_GTIN_ADD_1 | [NAME] | 5 | D2C Product Quality Critical Review |  |  | 2024-11-05 00:00:00 | 2025-03-08 00:00:00 |  | 00:00:00
201573537 | PN414085 | 2024-11-05 00:00:00 | 2024-11-07 00:00:00 |  |  |  | 2024-11-12 00:00:00 | DM_ATTP_GSK_EU_GTIN_ADD_1 | [NAME] | 6 | PE Product Quality Critical Review |  |  | 2024-11-05 00:00:00 | 2025-03-08 00:00:00 |  | 00:00:00
201573537 | PN414085 | 2024-11-05 00:00:00 | 2024-11-07 00:00:00 |  |  |  | 2024-11-12 00:00:00 | DM_ATTP_GSK_EU_GTIN_ADD_1 | [NAME] | 7 | WM Product Quality Critical Review |  |  | 2024-11-05 00:00:00 | 2025-03-08 00:00:00 |  | 00:00:00
201573537 | PN414085 | 2024-11-05 00:00:00 | 2024-11-07 00:00:00 |  |  |  | 2024-11-12 00:00:00 | DM_ATTP_GSK_EU_GTIN_ADD_1 | [NAME] | 8 | Complete Notification & Inform Requestor |  |  | 2024-11-05 00:00:00 | 2025-03-08 00:00:00 |  | 00:00:00
201573533 | PN414085 | 2024-11-07 00:00:00 | 2024-11-07 00:00:00 |  |  |  | 2024-11-14 00:00:00 | [NAME] | TSRL REQ | 4 | Perform Independent Check | Perform peer review | PN414085 | 2024-11-07 00:00:00 | 2024-11-08 00:00:00 | 2024-11-07 00:00:00 | 13:27:31
201573533 | PN414085 | 2024-11-07 00:00:00 | 2024-11-07 00:00:00 |  |  |  | 2024-11-14 00:00:00 | [NAME] | TSCO REQ | 3 | Maintain Master Data | 1 GTIN maste data Add SLT | PN414085 | 2024-11-07 00:00:00 | 2024-11-11 00:00:00 | 2024-11-07 00:00:00 | 11:31:57
201573533 | PN414085 | 2024-11-07 00:00:00 | 2024-11-07 00:00:00 |  |  |  | 2024-11-14 00:00:00 | [NAME] | TSCO SKP | 1 | DCF Task | Data Provided | PN414085 | 2024-11-07 00:00:00 | 2025-03-11 00:00:00 | 2024-11-07 00:00:00 | 11:16:10
201573533 | PN414085 | 2024-11-07 00:00:00 | 2024-11-07 00:00:00 |  |  |  | 2024-11-14 00:00:00 | [NAME] | TSCO SKP | 2 | QA Approval Required to Proceed? | Approved, see long text | PN414085 | 2024-11-07 00:00:00 | 2025-03-11 00:00:00 | 2024-11-07 00:00:00 | 11:16:10
201573533 | PN414085 | 2024-11-07 00:00:00 | 2024-11-07 00:00:00 |  |  |  | 2024-11-14 00:00:00 | [NAME] | TSCO SKP | 5 | D2C Product Quality Critical Review | Skipped | PN414085 | 2024-11-07 00:00:00 | 2025-03-11 00:00:00 | 2024-11-07 00:00:00 | 11:16:10
201573533 | PN414085 | 2024-11-07 00:00:00 | 2024-11-07 00:00:00 |  |  |  | 2024-11-14 00:00:00 | [NAME] | TSCO SKP | 6 | PE Product Quality Critical Review | Skipped | PN414085 | 2024-11-07 00:00:00 | 2025-03-11 00:00:00 | 2024-11-07 00:00:00 | 11:16:10
201573533 | PN414085 | 2024-11-07 00:00:00 | 2024-11-07 00:00:00 |  |  |  | 2024-11-14 00:00:00 | [NAME] | TSCO SKP | 7 | WM Product Quality Critical Review | Skipped | PN414085 | 2024-11-07 00:00:00 | 2025-03-11 00:00:00 | 2024-11-07 00:00:00 | 11:16:10
201573533 | PN414085 | 2024-11-07 00:00:00 | 2024-11-07 00:00:00 |  |  |  | 2024-11-14 00:00:00 | [NAME] | [NAME] | 8 | Complete Notification & Inform Requestor |  |  | 2024-11-07 00:00:00 | 2025-03-11 00:00:00 |  | 00:00:00
201573448 | CB832551 | 2024-11-07 00:00:00 | 2024-11-07 00:00:00 |  |  |  | 2024-11-14 00:00:00 | DM_ATTP_GSK_EU_DECOM_PARTIAL_W32F | TSRL REQ | 2 | QA Approval Required to Proceed? | Approval Task | CB832551 | 2024-11-07 00:00:00 | 2024-11-08 00:00:00 | 2024-11-07 00:00:00 | 11:23:21
201573448 | CB832551 | 2024-11-07 00:00:00 | 2024-11-07 00:00:00 |  |  |  | 2024-11-14 00:00:00 | DM_ATTP_GSK_EU_DECOM_PARTIAL_W32F | TSCO SKP | 1 | DCF Task | N/A - Data Provided | CB832551 | 2024-11-07 00:00:00 | 2024-11-11 00:00:00 | 2024-11-07 00:00:00 | 11:23:01
201573448 | CB832551 | 2024-11-07 00:00:00 | 2024-11-07 00:00:00 |  |  |  | 2024-11-14 00:00:00 | DM_ATTP_GSK_EU_DECOM_PARTIAL_W32F | [NAME] | 3 | Maintain Master Data | Partial Batch Decommissioning | CB832551 | 2024-11-07 00:00:00 | 2025-03-11 00:00:00 | 2024-11-07 00:00:00 | 11:11:29
201573448 | CB832551 | 2024-11-07 00:00:00 | 2024-11-07 00:00:00 |  |  |  | 2024-11-14 00:00:00 | DM_ATTP_GSK_EU_DECOM_PARTIAL_W32F | [NAME] | 4 | Perform Independent Check | Perform peer review | CB832551 | 2024-11-07 00:00:00 | 2025-03-11 00:00:00 | 2024-11-07 00:00:00 | 11:11:29
201573448 | CB832551 | 2024-11-07 00:00:00 | 2024-11-07 00:00:00 |  |  |  | 2024-11-14 00:00:00 | DM_ATTP_GSK_EU_DECOM_PARTIAL_W32F | [NAME] | 5 | D2C Product Quality Critical Review | Skipped | CB832551 | 2024-11-07 00:00:00 | 2025-03-11 00:00:00 | 2024-11-07 00:00:00 | 11:11:29
201573448 | CB832551 | 2024-11-07 00:00:00 | 2024-11-07 00:00:00 |  |  |  | 2024-11-14 00:00:00 | DM_ATTP_GSK_EU_DECOM_PARTIAL_W32F | [NAME] | 6 | PE Product Quality Critical Review | Skipped | CB832551 | 2024-11-07 00:00:00 | 2025-03-11 00:00:00 | 2024-11-07 00:00:00 | 11:11:29
201573448 | CB832551 | 2024-11-07 00:00:00 | 2024-11-07 00:00:00 |  |  |  | 2024-11-14 00:00:00 | DM_ATTP_GSK_EU_DECOM_PARTIAL_W32F | [NAME] | 7 | WM Product Quality Critical Review | Skipped | CB832551 | 2024-11-07 00:00:00 | 2025-03-11 00:00:00 | 2024-11-07 00:00:00 | 11:11:29
201573448 | CB832551 | 2024-11-07 00:00:00 | 2024-11-07 00:00:00 |  |  |  | 2024-11-14 00:00:00 | DM_ATTP_GSK_EU_DECOM_PARTIAL_W32F | [NAME] | 8 | Complete Notification & Inform Requestor | Informed requestor | CB832551 | 2024-11-07 00:00:00 | 2025-03-11 00:00:00 | 2024-11-07 00:00:00 | 11:11:29
201573238 | JL096847 | 2024-11-06 00:00:00 | 2024-11-06 00:00:00 |  |  |  | 2024-11-13 00:00:00 | DM_ATTP_GSK_MULTI_GTIN_OBS_15 | TSRL REQ | 3 | Maintain Master Data | OBS 15 GTINs | JL096847 | 2024-11-07 00:00:00 | 2024-11-11 00:00:00 | 2024-11-08 00:00:00 | 00:48:47
201573238 | JL096847 | 2024-11-06 00:00:00 | 2024-11-06 00:00:00 |  |  |  | 2024-11-13 00:00:00 | DM_ATTP_GSK_MULTI_GTIN_OBS_15 | TSCO SKP | 1 | DCF Task | Data Provided |  | 2024-11-07 00:00:00 | 2025-03-11 00:00:00 |  | 00:00:00
201573238 | JL096847 | 2024-11-06 00:00:00 | 2024-11-06 00:00:00 |  |  |  | 2024-11-13 00:00:00 | DM_ATTP_GSK_MULTI_GTIN_OBS_15 | TSCO SKP | 2 | QA Approval Required to Proceed? | Approval task |  | 2024-11-07 00:00:00 | 2025-03-11 00:00:00 |  | 00:00:00
201573238 | JL096847 | 2024-11-06 00:00:00 | 2024-11-06 00:00:00 |  |  |  | 2024-11-13 00:00:00 | DM_ATTP_GSK_MULTI_GTIN_OBS_15 | [NAME] | 4 | Perform Independent Check | Perform peer review |  | 2024-11-07 00:00:00 | 2025-03-11 00:00:00 |  | 00:00:00
201573238 | JL096847 | 2024-11-06 00:00:00 | 2024-11-06 00:00:00 |  |  |  | 2024-11-13 00:00:00 | DM_ATTP_GSK_MULTI_GTIN_OBS_15 | TSCO SKP | 5 | D2C Product Quality Critical Review | Skipped |  | 2024-11-07 00:00:00 | 2025-03-11 00:00:00 |  | 00:00:00
201573238 | JL096847 | 2024-11-06 00:00:00 | 2024-11-06 00:00:00 |  |  |  | 2024-11-13 00:00:00 | DM_ATTP_GSK_MULTI_GTIN_OBS_15 | TSCO SKP | 6 | PE Product Quality Critical Review | Skipped |  | 2024-11-07 00:00:00 | 2025-03-11 00:00:00 |  | 00:00:00
201573238 | JL096847 | 2024-11-06 00:00:00 | 2024-11-06 00:00:00 |  |  |  | 2024-11-13 00:00:00 | DM_ATTP_GSK_MULTI_GTIN_OBS_15 | TSCO SKP | 7 | WM Product Quality Critical Review | Skipped |  | 2024-11-07 00:00:00 | 2025-03-11 00:00:00 |  | 00:00:00
201573238 | JL096847 | 2024-11-06 00:00:00 | 2024-11-06 00:00:00 |  |  |  | 2024-11-13 00:00:00 | DM_ATTP_GSK_MULTI_GTIN_OBS_15 | [NAME] | 8 | Complete Notification & Inform Requestor | Informed requestor |  | 2024-11-07 00:00:00 | 2025-03-11 00:00:00 |  | 00:00:00
201573236 | JL096847 | 2024-11-06 00:00:00 | 2024-11-06 00:00:00 |  |  |  | 2024-11-13 00:00:00 | DM_ATTP_GSK_EU_DECOM_VH5F_1 | [NAME] | 3 | Maintain Master Data | Partial [NAME],SLT | JL096847 | 2024-11-08 00:00:00 | 2024-11-12 00:00:00 | 2024-11-08 00:00:00 | 00:50:14