Spreadsheet: 743909d1628803783-extracting-max-date-based-on-multiple-criterias-that-match-a-specific-status-bernies-sample-data-for-idgs
Sheet: Sheet1

Patient | IDG Date | Discipline | Role Status1 | Signed Date | Column1
Example, Sample 1 | 2021-05-05 00:00:00 | SOCIAL WORKER | SIGNED | 2021-05-05 00:00:00
Example, Sample 1 | 2021-05-05 00:00:00 | MEDICAL DIRECTOR | OPEN
Example, Sample 1 | 2021-05-05 00:00:00 | PASTOR/COUNSELOR | SIGNED
Example, Sample 1 | 2021-05-05 00:00:00 | REGISTERED NURSE | SIGNED | 2021-05-05 00:00:00
Example, Sample 1 | 2021-05-19 00:00:00 | SOCIAL WORKER | SIGNED | 2021-05-06 00:00:00
Example, Sample 1 | 2021-05-19 00:00:00 | MEDICAL DIRECTOR | OPEN
Example, Sample 1 | 2021-05-19 00:00:00 | PASTOR/COUNSELOR | OPEN
Example, Sample 1 | 2021-05-19 00:00:00 | REGISTERED NURSE | SIGNED | 2021-05-18 00:00:00
Example, Sample 1 | 2021-06-02 00:00:00 | SOCIAL WORKER | SIGNED | 2021-05-27 00:00:00
Example, Sample 1 | 2021-06-02 00:00:00 | MEDICAL DIRECTOR | OPEN
Example, Sample 1 | 2021-06-02 00:00:00 | PASTOR/COUNSELOR | OPEN
Example, Sample 1 | 2021-06-02 00:00:00 | REGISTERED NURSE | SIGNED | 2021-06-02 00:00:00
Example, Sample 1 | 2021-06-16 00:00:00 | SOCIAL WORKER | SIGNED | 2021-06-11 00:00:00
Example, Sample 1 | 2021-06-16 00:00:00 | MEDICAL DIRECTOR | OPEN
Example, Sample 1 | 2021-06-16 00:00:00 | PASTOR/COUNSELOR | OPEN
Example, Sample 1 | 2021-06-16 00:00:00 | REGISTERED NURSE | SIGNED | 2021-06-15 00:00:00
Example, Sample 1 | 2021-06-30 00:00:00 | SOCIAL WORKER | SIGNED | 2021-06-24 00:00:00
Example, Sample 1 | 2021-06-30 00:00:00 | MEDICAL DIRECTOR | OPEN
Example, Sample 1 | 2021-06-30 00:00:00 | PASTOR/COUNSELOR | OPEN
Example, Sample 1 | 2021-06-30 00:00:00 | REGISTERED NURSE | SIGNED | 2021-06-29 00:00:00
Example, Sample 1 | 2021-07-14 00:00:00 | SOCIAL WORKER | SIGNED | 2021-07-08 00:00:00
Example, Sample 1 | 2021-07-14 00:00:00 | MEDICAL DIRECTOR | OPEN
Example, Sample 1 | 2021-07-14 00:00:00 | PASTOR/COUNSELOR | OPEN
Example, Sample 1 | 2021-07-14 00:00:00 | REGISTERED NURSE | OPEN
Example, Sample 1 | 2021-07-21 00:00:00 | SOCIAL WORKER | SIGNED | 2021-07-21 00:00:00
Example, Sample 1 | 2021-07-21 00:00:00 | MEDICAL DIRECTOR | OPEN
Example, Sample 1 | 2021-07-21 00:00:00 | PASTOR/COUNSELOR | OPEN
Example, Sample 1 | 2021-07-21 00:00:00 | REGISTERED NURSE | OPEN
Example, Sample 1 | 2021-07-28 00:00:00 | SOCIAL WORKER | SIGNED | 2021-07-22 00:00:00
Example, Sample 1 | 2021-07-28 00:00:00 | MEDICAL DIRECTOR | OPEN
Example, Sample 1 | 2021-07-28 00:00:00 | PASTOR/COUNSELOR | OPEN
Example, Sample 1 | 2021-07-28 00:00:00 | REGISTERED NURSE | OPEN
Example, Sample 2 | 2019-06-18 00:00:00 | REGISTERED NURSE | SIGNED | 2019-06-18 00:00:00
Example, Sample 2 | 2019-06-18 00:00:00 | PASTOR/COUNSELOR | SIGNED | 2019-06-17 00:00:00
Example, Sample 2 | 2019-06-18 00:00:00 | MEDICAL DIRECTOR | OPEN
Example, Sample 2 | 2019-06-18 00:00:00 | SOCIAL WORKER | SIGNED | 2019-06-21 00:00:00
Example. Sample 3 | 2020-11-17 00:00:00 | REGISTERED NURSE | SIGNED | 2020-11-20 00:00:00
Example. Sample 3 | 2020-11-17 00:00:00 | SOCIAL WORKER | SIGNED | 2020-11-17 00:00:00
Example. Sample 3 | 2020-11-17 00:00:00 | PASTOR/COUNSELOR | SIGNED | 2020-11-15 00:00:00
Example. Sample 3 | 2020-11-17 00:00:00 | MEDICAL DIRECTOR | OPEN