Spreadsheet: 878528d1725629916-need-a-formula-to-sum-a-column-based-on-repeated-consecutive-cells-in-another-column-projects-dashboard-test-file
Sheet: FG - TEST

 | SG# | Activity/Event | Team Accountable | Date | End | #Days | Modified #days | 7 day Target Met?
 | SG 1.0 | DSP Received Officially | PL(CS) | 2023-04-26 00:00:00
 |  | Meeting/Peer review conducted | RT/CT | 2023-05-15 00:00:00
 |  | Revised DSP received | RT/CT | 2023-05-24 00:00:00
 |  | Meeting/Peer review conducted | CPA | 2023-05-25 00:00:00
 |  | Comments sent to RT/CT | CPA | 2023-05-28 00:00:00
 |  | Comments sent to RT/CT | CPA | 2023-05-29 00:00:00
 |  | Meeting/Peer review conducted | PRC | 2023-06-01 00:00:00
 |  | Revised DSP received | PL(CS) | 2023-06-08 00:00:00
 |  | Comments sent to RT/CT | RT/CT | 2023-06-15 00:00:00
 |  | Meeting/Peer review conducted | RT/CT | 2023-06-15 00:00:00
 |  | Revised DSP received | PL(CS) | 2023-06-15 00:00:00
 |  | Comments sent to RT/CT | RT/CT | 2023-06-15 00:00:00
 |  | Response to PL(CS) comments received | PL(CS) | 2023-07-04 00:00:00
 |  | Comments sent to RT/CT | RT/CT | 2023-07-04 00:00:00
 |  | Response to PL(CS) comments received | PL(CS) | 2023-07-17 00:00:00
 |  | Comments sent to RT/CT | RT/CT | 2023-07-18 00:00:00
 |  | Revised DSP received | PL(CS) | 2023-07-23 00:00:00
 |  | Comments sent to RT/CT | RT/CT | 2023-07-24 00:00:00
 |  | Response to PL(CS) comments received | PL(CS) | 2023-07-24 00:00:00
 |  | DSP sent to CPA Team | CPA | 2023-07-25 00:00:00
 |  | CPA clarifications received | PL(CS) | 2023-07-31 00:00:00
 |  | RT/CT response forwarded to CPA | CPA | 2023-07-31 00:00:00
 |  | CPA clarifications received | PL(CS) | 2023-08-02 00:00:00
 |  | CPA clarifications forwarded to RT/CT | RT/CT | 2023-08-02 00:00:00
 |  | Response to CPA's first round received | PL(CS) | 2023-08-07 00:00:00
 |  | Comments sent to RT/CT | RT/CT | 2023-08-07 00:00:00
 |  | Response to PL(CS) comments received | PL(CS) | 2023-08-08 00:00:00
 |  | RT/CT response forwarded to CPA | CPA | 2023-08-09 00:00:00
 |  | CPA clarifications received | PL(CS) | 2023-08-17 00:00:00
 |  | CPA clarifications forwarded to RT/CT | RT/CT | 2023-08-17 00:00:00
 |  | Reminder sent | RT/CT | 2023-08-24 00:00:00
 |  | Response to CPA's second round received | PL(CS) | 2023-08-24 00:00:00
 |  | RT/CT response forwarded to CPA | RT/CT | 2023-08-24 00:00:00
 |  | Response to CPA's second round received | PL(CS) | 2023-08-27 00:00:00
 |  | Comments sent to RT/CT | RT/CT | 2023-08-28 00:00:00
 |  | Response to CPA's second round received | PL(CS) | 2023-08-29 00:00:00
 |  | RT/CT response forwarded to CPA | RT/CT | 2023-08-30 00:00:00
 |  | CPA clarifications received | PL(CS) | 2023-09-04 00:00:00
 |  | CPA clarifications forwarded to RT/CT | RT/CT | 2023-09-04 00:00:00
 |  | Response to CPA's third round received | PL(CS) | 2023-09-05 00:00:00
 |  | RT/CT response forwarded to CPA | CPA | 2023-09-05 00:00:00
 |  | CPA clarifications received | PL(CS) | 2023-09-05 00:00:00
 |  | CPA clarifications forwarded to RT/CT | RT/CT | 2023-09-05 00:00:00
 |  | Response to CPA's third round received | PL(CS) | 2023-09-06 00:00:00
 |  | RT/CT response forwarded to CPA | RT/CT | 2023-09-06 00:00:00
 |  | CPA clarifications received | PL(CS) | 2023-09-10 00:00:00
 |  | CPA clarifications forwarded to RT/CT | RT/CT | 2023-09-10 00:00:00
 |  | Response to CPA's round of clarifications received | PL(CS) | 2023-09-10 00:00:00
 |  | RT/CT response forwarded to CPA | CPA | 2023-09-10 00:00:00
 |  | CPA clarifications received | PL(CS) | 2023-09-11 00:00:00
 |  | CPA clarifications forwarded to RT/CT | RT/CT | 2023-09-11 00:00:00
 |  | Response to CPA's round of clarifications received | PL(CS) | 2023-09-11 00:00:00
 |  | RT/CT response forwarded to CPA | CPA | 2023-09-11 00:00:00
 |  | CPA clarifications received | PL(CS) | 2023-09-12 00:00:00
 |  | CPA clarifications forwarded to RT/CT | RT/CT | 2023-09-12 00:00:00
 |  | Response to CPA's round of clarifications received | PL(CS) | 2023-09-12 00:00:00
 |  | RT/CT response forwarded to CPA | PRC | 2023-09-12 00:00:00
 |  | Other | PL(CS) | 2023-09-18 00:00:00
 |  | Comments sent to RT/CT | RT/CT | 2023-09-19 00:00:00
 |  | Response to PL(CS) comments received | PL(CS) | 2023-09-19 00:00:00
 |  | RT/CT response forwarded to CPA | CPA | 2023-09-19 00:00:00
 |  | Other | NA | 2023-09-19 00:00:00
 |  | DSP returned | PL(CS) | 2023-09-19 00:00:00
 |  | DSP returned to CT/RT | RT/CT | 2023-09-21 00:00:00
 | SG1.0 & SG2.0 | Reminder sent | RT/CT | 2023-11-22 00:00:00
 |  | Response to PL(CS) comments received | RT/CT | 2023-11-23 00:00:00
 |  | Meeting requested | NA | 2023-11-23 00:00:00
 |  | Meeting/Peer review conducted | RT/CT | 2023-12-11 00:00:00
 |  | DSP received unofficially | PL(CS) | 2024-01-02 00:00:00
 |  | Comments sent to RT/CT | RT/CT | 2024-01-03 00:00:00
 |  | Revised DSP received | PL(CS) | 2024-01-07 00:00:00
 |  | Comments sent to RT/CT | RT/CT | 2024-01-09 00:00:00
 |  | Revised DSP received | PL(CS) | 2024-01-10 00:00:00
 |  | Meeting requested | PL(CS) | 2024-01-14 00:00:00
 |  | Meeting/Peer review conducted | PL(CS) | 2024-01-17 00:00:00
 |  | Comments sent to RT/CT | RT/CT | 2024-01-21 00:00:00
 |  | Meeting requested | RT/CT | 2024-01-21 00:00:00
 |  | Response to PL(CS) comments received | RT/CT | 2024-01-23 00:00:00
 |  | Meeting/Peer review conducted | RT/CT | 2024-01-31 00:00:00
 |  | Response to PL(CS) comments received | PL(CS) | 2024-02-01 00:00:00
 |  | Comments sent to RT/CT | RT/CT | 2024-02-01 00:00:00
 |  | Response to PL(CS) comments received | PL(CS) | 2024-02-05 00:00:00
 |  | Comments sent to RT/CT | RT/CT | 2024-02-05 00:00:00
 |  | Revised DSP received | PL(CS) | 2024-02-11 00:00:00
 |  | Response to PL(CS) comments received | PL(CS) | 2024-02-12 00:00:00
 |  | Response to PL(CS) comments received | PL(CS) | 2024-02-13 00:00:00
 |  | Other | NA | 2024-02-15 00:00:00
 |  | Revised DSP received | PL(CS) | 2024-03-03 00:00:00
 |  | Comments sent to RT/CT | RT/CT | 2024-03-18 00:00:00
 |  | Revised DSP received | PL(CS) | 2024-03-26 00:00:00
 |  | Comments sent to RT/CT | PL(CS) | 2024-03-27 00:00:00
 |  | DSP sent to CPA Team | CPA | 2024-03-28 00:00:00
 |  | CPA clarifications received | PL(CS) | 2024-04-14 00:00:00
 |  | CPA clarifications forwarded to RT/CT | RT/CT | 2024-04-15 00:00:00
 |  | Response to CPA's first round received | PL(CS) | 2024-04-18 00:00:00
 |  | Comments sent to RT/CT | RT/CT | 2024-04-21 00:00:00
 |  | Response to CPA's first round received | PL(CS) | 2024-04-21 00:00:00
 |  | RT/CT response forwarded to CPA | CPA | 2024-04-22 00:00:00
 |  | CPA clarifications received | PL(CS) | 2024-04-29 00:00:00
 |  | CPA clarifications forwarded to RT/CT | RT/CT | 2024-04-30 00:00:00
 |  | Response to CPA's second round received | PL(CS) | 2024-05-01 00:00:00
 |  | Comments sent to RT/CT | RT/CT | 2024-05-01 00:00:00
 |  | Response to CPA's second round received | PL(CS) | 2024-05-05 00:00:00
 |  | Comments sent to RT/CT | RT/CT | 2024-05-05 00:00:00
 |  | Response to CPA's second round received | PL(CS) | 2024-05-05 00:00:00
 |  | RT/CT response forwarded to CPA | CPA | 2024-05-06 00:00:00 |  |  |  | NA
 |  | Other | PL(CS) | 2024-05-07 00:00:00
 |  | RT/CT response forwarded to CPA | CPA | 2024-05-07 00:00:00
 |  | PRC slides requested by CPA | PL(CS) | 2024-05-13 00:00:00
 |  | Comments sent to RT/CT | RT/CT | 2024-05-14 00:00:00
 |  | PRC slides received from RT/CT | PL(CS) | 2024-05-14 00:00:00
 |  | PRC slides forwarded to CPA | CPA | 2024-05-14 00:00:00
 |  | Comments sent to RT/CT | RT/CT | 2024-05-15 00:00:00
 |  | Response to CPA's round of clarifications received | PL(CS) | 2024-05-15 00:00:00
 |  | RT/CT response forwarded to CPA | CPA | 2024-05-15 00:00:00
 |  | Meeting/Peer review conducted | RT/CT | 2024-05-26 00:00:00
 |  | CPA clarifications received by Planning Team | PL(CS) | 2024-05-26 00:00:00
 |  | CPA clarifications forwarded to RT/CT | RT/CT | 2024-05-26 00:00:00
 |  | Response to CPA's round of clarifications received | PL(CS) | 2024-05-27 00:00:00
 |  | RT/CT response forwarded to CPA | CPA | 2024-05-27 00:00:00
 |  | PRC slides requested by CPA | PL(CS) | 2024-05-29 00:00:00
 |  | Comments sent to RT/CT | RT/CT | 2024-05-29 00:00:00
 |  | PRC slides received from RT/CT | PL(CS) | 2024-05-30 00:00:00
 |  | PRC slides forwarded to CPA | CPA | 2024-05-30 00:00:00
 |  | PRC slides requested by CPA | PL(CS) | 2024-05-30 00:00:00
 |  | Comments sent to RT/CT | RT/CT | 2024-05-30 00:00:00
 |  | PRC slides received from RT/CT | PL(CS) | 2024-06-02 00:00:00
 |  | PRC slides forwarded to CPA | LC | 2024-06-02 00:00:00
 |  | PRC/LC conducted | CPA | 2024-06-10 00:00:00
 |  | SG closed by PRC/LC | NA | 2024-06-13 00:00:00
 |  | SG closed by PRC/LC | RT/CT | 2024-06-13 00:00:00
 |  | CPP Received on eBeams | PL(CS) | 2024-06-25 00:00:00
 |  | CPP forwarded to the CT for their action | RT/CT | 2024-06-25 00:00:00
 |  | CPP Received on eBeams | PL(CS) | 2024-06-25 00:00:00
 |  | CPP forwarded to CPA Team | CPA | 2024-06-25 00:00:00
 | SG3.1 |  | NA
 |  |  | NA
 |  |  | NA
 |  |  | NA
 |  |  | NA
 |  |  | NA
 |  |  | NA
 |  |  | NA
 |  |  | NA
 |  |  | NA
 |  |  | NA
 |  |  | NA
 |  |  | NA
 |  |  | NA
 |  |  | NA
 |  |  | NA
 |  |  | NA
 |  |  | NA
 |  |  | NA
 |  |  | NA
 |  |  | NA
 |  |  | NA
 |  |  | NA
 |  |  | NA
 |  |  | NA
 |  |  | NA
 |  |  | NA
 |  |  | NA
 |  |  | NA
 |  |  | NA
 |  |  | NA
 |  |  | NA
 |  |  | NA
 |  |  | NA
 |  |  | NA
 |  |  | NA
 |  |  | NA
 |  |  | NA
 |  |  | NA
 |  |  | NA
 |  |  | NA
 |  |  | NA