Spreadsheet: 715128d1611580442-sum-on-a-pivot-table-column-with-multiple-criteria-match-person-between-two-dates-resource-planning-dashboard_help
Sheet: Data

Team Member | Type | Status | Allocation | Start Date | End Date | Duration
Ellen | Implementation | In progress | 0.35 | 2021-01-25 00:00:00 | 2021-02-05 00:00:00
Troy | Implementation | In progress | 0.35 | 2021-01-25 00:00:00 | 2021-03-05 00:00:00
[NAME] | Implementation | In progress | 0.04 | 2021-01-25 00:00:00 | 2021-02-05 00:00:00 |  |  | [NAME] | 2021-03-01 00:00:00
[NAME] | Implementation | On hold | 0.04 | 2021-02-01 00:00:00 | 2021-02-01 00:00:00
[NAME] | Implementation | On hold | 0.35 | 2021-02-01 00:00:00 | 2021-02-01 00:00:00
[NAME] | Implementation | In progress | 0.35 | 2021-01-25 00:00:00 | 2021-02-28 00:00:00
[NAME] | Implementation | In progress | 0.35 | 2021-01-25 00:00:00 | 2021-02-28 00:00:00
[NAME] | Implementation | In progress | 0.04 | 2021-01-25 00:00:00 | 2021-02-28 00:00:00
[NAME] | Implementation | In progress | 0.04 | 2021-01-25 00:00:00 | 2021-02-28 00:00:00
[NAME] | Customer Success | In progress | 0.35 | 2021-02-01 00:00:00 | 2021-02-01 00:00:00
[NAME] | Customer Success | In progress | 0.04 | 2021-02-01 00:00:00 | 2021-02-01 00:00:00
[NAME] | Customer Success | In progress | 0.04 | 2021-02-01 00:00:00 | 2021-02-01 00:00:00
Ellen | Implementation | Not Started | 0.1 | 2021-01-29 00:00:00 |  | 5
[NAME] | Implementation | Not Started | 0.35 | 2021-01-29 00:00:00 |  | 5
[NAME] | Implementation | Not Started | 0.35 | 2021-01-29 00:00:00 |  | 5
[NAME] | Implementation | Not Started | 0.04 | 2021-01-29 00:00:00 |  | 5
[NAME] | Implementation | Not Started | 0.04 | 2021-01-29 00:00:00 |  | 5
Ellen | Implementation | Not Started | 0.1 | 2021-02-01 00:00:00 | 2021-02-01 00:00:00
[NAME] | Implementation | Not Started | 0.35 | 2021-02-01 00:00:00 | 2021-02-01 00:00:00
[NAME] | Implementation | Not Started | 0.35 | 2021-02-01 00:00:00 | 2021-02-01 00:00:00
[NAME] | Implementation | Not Started | 0.04 | 2021-02-01 00:00:00 | 2021-02-01 00:00:00
[NAME] | Implementation | Not Started | 0.04 | 2021-02-01 00:00:00 | 2021-02-01 00:00:00
Ellen | Implementation | In progress | 0.35 | 2021-01-25 00:00:00 | 2021-06-12 00:00:00
[NAME] | Implementation | In progress | 0.35 | 2021-01-25 00:00:00 | 2021-06-12 00:00:00
[NAME] | Implementation | In progress | 0.35 | 2021-01-25 00:00:00 | 2021-06-12 00:00:00
[NAME] | Implementation | In progress | 0.04 | 2021-01-25 00:00:00 | 2021-06-12 00:00:00
[NAME] | Implementation | In progress | 0.04 | 2021-01-25 00:00:00 | 2021-06-12 00:00:00
[NAME] | Implementation | In progress | 0.5 | 2021-01-25 00:00:00 | 2021-06-01 00:00:00
[NAME] | Implementation | In progress | 0.5 | 2021-01-25 00:00:00 | 2021-06-01 00:00:00
[NAME] | Implementation | In progress | 0.5 | 2021-01-25 00:00:00 | 2021-06-01 00:00:00
[NAME] | Implementation | In progress | 0.25 | 2021-01-25 00:00:00 | 2021-06-01 00:00:00
[NAME] | Implementation | In progress | 0.25 | 2021-01-25 00:00:00 | 2021-06-01 00:00:00
[NAME] | Implementation | In progress | 0.04 | 2021-01-25 00:00:00 | 2021-06-01 00:00:00
[NAME] | Implementation | In progress | 0.04 | 2021-01-25 00:00:00 | 2021-06-01 00:00:00
Troy | Implementation | In progress | 0.1 | 2021-01-25 00:00:00 | 2021-06-01 00:00:00
[NAME] | Implementation | In progress | 0.5 | 2021-01-25 00:00:00 | 2021-06-01 00:00:00
[NAME] | Implementation | In progress | 0.5 | 2021-01-25 00:00:00 | 2021-06-01 00:00:00
[NAME] | Implementation | In progress | 0.5 | 2021-01-25 00:00:00 | 2021-06-01 00:00:00
[NAME] | Implementation | In progress | 0.25 | 2021-01-25 00:00:00 | 2021-06-01 00:00:00
[NAME] | Implementation | In progress | 0.25 | 2021-01-25 00:00:00 | 2021-06-01 00:00:00
[NAME] | Implementation | In progress | 0.04 | 2021-01-25 00:00:00 | 2021-06-01 00:00:00
[NAME] | Implementation | In progress | 0.04 | 2021-01-25 00:00:00 | 2021-06-01 00:00:00
[NAME] | Other | In progress | 0.1 | 2021-01-25 00:00:00 | 2021-10-01 00:00:00
[NAME] | Other | In progress | 0.35 | 2021-01-25 00:00:00 | 2021-10-01 00:00:00
Troy | Other | In progress | 0.35 | 2021-01-25 00:00:00 | 2021-10-01 00:00:00
Ellen | Implementation | In progress | 0.27 | 2021-01-25 00:00:00 | 2021-05-31 00:00:00
[NAME] | Implementation | In progress | 0.35 | 2021-01-25 00:00:00 | 2021-05-31 00:00:00
[NAME] | Implementation | In progress | 0.35 | 2021-01-25 00:00:00 | 2021-05-31 00:00:00
[NAME] | Implementation | In progress | 0.04 | 2021-01-25 00:00:00 | 2021-05-31 00:00:00
[NAME] | Implementation | In progress | 0.04 | 2021-01-25 00:00:00 | 2021-05-31 00:00:00
Ellen | Implementation | In progress | 0.27 | 2021-01-25 00:00:00 | 2021-06-30 00:00:00
[NAME] | Implementation | In progress | 0.35 | 2021-01-25 00:00:00 | 2021-06-30 00:00:00
[NAME] | Implementation | In progress | 0.35 | 2021-01-25 00:00:00 | 2021-06-30 00:00:00
[NAME] | Implementation | In progress | 0.04 | 2021-01-25 00:00:00 | 2021-06-30 00:00:00
Unassigned | Implementation | In progress | 0.04 | 2021-01-25 00:00:00 | 2021-06-30 00:00:00
Ellen | Implementation | In progress | 0.1 | 2021-01-25 00:00:00 | 2021-07-01 00:00:00
[NAME] | Implementation | In progress | 0.35 | 2021-01-25 00:00:00 | 2021-07-01 00:00:00
[NAME] | Implementation | In progress | 0.35 | 2021-01-25 00:00:00 | 2021-07-01 00:00:00
[NAME] | Implementation | In progress | 0.04 | 2021-01-25 00:00:00 | 2021-07-01 00:00:00
[NAME] | Implementation | In progress | 0.04 | 2021-01-25 00:00:00 | 2021-07-01 00:00:00
Ellen | Implementation | In progress | 0.27 | 2021-01-25 00:00:00 | 2021-07-31 00:00:00
[NAME] | Implementation | In progress | 0.35 | 2021-01-25 00:00:00 | 2021-07-31 00:00:00
[NAME] | Implementation | In progress | 0.35 | 2021-01-25 00:00:00 | 2021-07-31 00:00:00
[NAME] | Implementation | In progress | 0.04 | 2021-01-25 00:00:00 | 2021-07-31 00:00:00
Unassigned | Implementation | In progress | 0.04 | 2021-01-25 00:00:00 | 2021-07-31 00:00:00
Ellen | Implementation | In progress | 0.27 | 2021-01-25 00:00:00 | 2021-12-31 00:00:00
[NAME] | Implementation | In progress | 0.35 | 2021-01-25 00:00:00 | 2021-12-31 00:00:00
[NAME] | Implementation | In progress | 0.35 | 2021-01-25 00:00:00 | 2021-12-31 00:00:00
[NAME] | Implementation | In progress | 0.04 | 2021-01-25 00:00:00 | 2021-12-31 00:00:00
Unassigned | Implementation | In progress | 0.04 | 2021-01-25 00:00:00 | 2021-12-31 00:00:00
[NAME] | Implementation | In progress | 0.5 | 2021-01-25 00:00:00 | 2022-05-22 00:00:00
[NAME] | Implementation | In progress | 0.5 | 2021-01-25 00:00:00 | 2022-05-22 00:00:00
Troy | Implementation | In progress | 0.5 | 2021-01-25 00:00:00 | 2022-05-22 00:00:00
[NAME] | Implementation | In progress | 0.25 | 2021-01-25 00:00:00 | 2022-05-22 00:00:00
[NAME] | Implementation | In progress | 0.25 | 2021-01-25 00:00:00 | 2022-05-22 00:00:00
[NAME] | Implementation | In progress | 0.5 | 2021-01-25 00:00:00 | 2022-05-22 00:00:00
[NAME] | Implementation | In progress | 0.5 | 2021-01-25 00:00:00 | 2022-05-22 00:00:00
[NAME] | Implementation | In progress | 0.5 | 2021-01-25 00:00:00 | 2022-05-22 00:00:00
Troy | Implementation | In progress | 0.5 | 2021-01-25 00:00:00 | 2022-05-22 00:00:00
[NAME] | Implementation | In progress | 0.25 | 2021-01-25 00:00:00 | 2022-05-22 00:00:00
[NAME] | Implementation | In progress | 0.05 | 2021-01-25 00:00:00 | 2022-05-22 00:00:00
[NAME] | Implementation | In progress | 0.5 | 2021-01-25 00:00:00 | 2022-05-22 00:00:00
[NAME] | Implementation | In progress | 0.1 | 2021-01-25 00:00:00 | 2022-05-22 00:00:00
[NAME] | Implementation | In progress | 0.04 | 2021-01-25 00:00:00 | 2022-05-22 00:00:00
[NAME] | Implementation | In progress | 0.35 | 2021-01-25 00:00:00 | 2021-02-28 00:00:00