Book1 | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
1 | Key | Review ID | Folder Transition At | From Folder | To Folder | Review Classification | Folder Transition User Name | ||
2 | B2BJP2M6 | 11640201 | 3/6/2023 3:56:04 PM | New - Portal Created | Essential | Pharmacy | Not Found | ||
3 | 3/6/2023 4:00:48 PM | Essential | Pharmacist | Pharmacy | 0 | ||||
4 | 3/6/2023 4:07:26 PM | Pharmacist | URGENT Outreach 1 | Pharmacy | 0 | ||||
5 | 3/7/2023 9:49:44 AM | URGENT Outreach 1 | URGENT Outreach 2 | Pharmacy | 0 | ||||
6 | 3/8/2023 8:53:13 AM | URGENT Outreach 2 | URGENT Outreach 3 | Pharmacy | 0 | ||||
7 | B2BPXKWC | 11634758 | 3/3/2023 4:24:02 PM | New - Portal Created | Essential | Pharmacy | Denied | ||
8 | 3/3/2023 4:32:14 PM | Essential | Pharmacist ACA | Pharmacy | 0 | ||||
9 | 3/6/2023 10:10:47 AM | Pharmacist ACA | Callback | Pharmacy | 0 | ||||
10 | 3/6/2023 11:01:43 AM | Callback | ACA Notifications | Pharmacy | 0 | ||||
11 | 3/6/2023 12:42:56 PM | ACA Notifications | Closed | Pharmacy | 0 | ||||
12 | B2BQHGWH | 11643897 | 3/7/2023 12:14:24 PM | New - Portal Created | Essential | Pharmacy | Not Found | ||
13 | 3/7/2023 12:48:47 PM | Essential | Pharmacist | Pharmacy | 0 | ||||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
G2:G13 | G2 | =XLOOKUP(A2,'[BCBSNC - Custom - Closed Request Productivity (4).csv]BCBSNC - Custom - Closed Reques'!$D:$D,'[BCBSNC - Custom - Closed Request Productivity (4).csv]BCBSNC - Custom - Closed Reques'!$AB:$AB,"Not Found",0) |