Spreadsheet: 714006d1611056656-using-if-statement-with-a-unique-id-example-sheet
Sheet: DATA

Unique ID | Ticket Assignee | # Unsatisfied | # Satisfied | # Solved Tickets | Date | Week Num | Staffed Time | Pick Up % | Total Calls | Dial Attempts | Inbound | Outbound | Follow Up | Away | On Call | ACW | AVG Speed to Answer | Adherence | Month | Year
 | Agent 1 | 1 | 26 | 123 | 2021-01-04 00:00:00 | 2 | 1 day, 14:40:42 | 1 | 34 | 34 | 33 | 1 | 02:16:37 | 00:49:59 | 04:04:35 | 02:19:33 | 00:00:06 | 0.824 | Jan | 2021
 | Agent 2 | 4 | 25 | 191 | 2021-01-04 00:00:00 | 2 | 1 day, 11:41:09 | 1 | 33 | 35 | 32 | 1 | 00:29:04 | 02:33:47 | 03:29:15 | 01:01:48 | 00:00:07 | 0.7304 | Jan | 2021
 | Agent 3 | 1 | 12 | 109 | 2021-01-04 00:00:00 | 2 | 21:43:23 | 1 | 11 | 12 | 11 | 0 | 00:10:08 | 00:31:53 | 01:00:18 | 00:19:56 | 00:00:06 | 0.8333 | Jan | 2021
 | Agent 4 | 0 | 2 | 25 | 2021-01-04 00:00:00 | 2 | 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | Jan | 2021
 | Agent 5 | 1 | 18 | 182 | 2021-01-04 00:00:00 | 2 | 1 day, 7:02:34 | 0.9412 | 18 | 17 | 16 | 2 | 00:33:10 | 01:16:12 | 01:13:09 | 00:46:16 | 00:00:06 | 0.5956 | Jan | 2021
 | Agent 6 | 0 | 6 | 66 | 2021-01-04 00:00:00 | 2 | 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | Jan | 2021
 | Agent 7 | 0 | 36 | 431 | 2021-01-04 00:00:00 | 2 | 2 days, 4:59:33 | 1 | 19 | 19 | 19 | 0 | 00:26:00 | 00:42:36 | 01:16:00 | 01:01:59 | 00:00:04 | 0.6894 | Jan | 2021
 | Agent 8 | 0 | 26 | 174 | 2021-01-04 00:00:00 | 2 | 1 day, 12:00:13 | 0.9778 | 56 | 45 | 44 | 12 | 00:30:30 | 03:13:49 | 04:13:26 | 01:48:02 | 00:00:03 | 0.8203 | Jan | 2021
 | Agent 9 | 1 | 26 | 145 | 2021-01-04 00:00:00 | 2 | 1 day, 16:22:02 | 1 | 43 | 36 | 33 | 10 | 00:37:57 | 01:54:44 | 04:39:05 | 01:55:12 | 00:00:03 | 0.8768 | Jan | 2021
 | Agent 10 | 1 | 16 | 180 | 2021-01-04 00:00:00 | 2 | 1 day, 14:54:31 | 1 | 34 | 30 | 30 | 4 | 00:13:06 | 00:51:00 | 02:30:18 | 00:51:39 | 00:00:03 | 0.947 | Jan | 2021
 | Agent 11 | 1 | 28 | 183 | 2021-01-04 00:00:00 | 2 | 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | Jan | 2021
 | Agent 12 | 0 | 15 | 94 | 2021-01-04 00:00:00 | 2 | 05:43:02 | 1 | 11 | 11 | 11 | 0 | 00:00:00 | 00:00:00 | 02:57:08 | 00:16:10 | 00:00:05 | 0.8087 | Jan | 2021
 | Agent 13 | 3 | 30 | 154 | 2021-01-04 00:00:00 | 2 | 1 day, 14:00:23 | 1 | 37 | 39 | 37 | 0 | 01:01:51 | 01:22:13 | 03:38:25 | 01:23:35 | 00:00:08 | 0.8509 | Jan | 2021
 | Agent 14 | 0 | 0 | 4 | 2021-01-04 00:00:00 | 2 | 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | Jan | 2021
 | Agent 15 | 0 | 30 | 310 | 2021-01-04 00:00:00 | 2 | 1 day, 23:34:59 | 1 | 47 | 47 | 45 | 2 | 00:00:00 | 00:07:28 | 02:26:13 | 01:24:59 | 00:00:06 | 0.9277 | Jan | 2021
 | Agent 16 | 1 | 11 | 97 | 2021-01-04 00:00:00 | 2 | 1 day, 13:30:53 | 1 | 27 | 27 | 26 | 1 | 00:00:00 | 02:46:00 | 02:55:25 | 03:28:41 | 00:00:07 | 0.9128 | Jan | 2021
 | Agent 17 | 0 | 1 | 23 | 2021-01-04 00:00:00 | 2 | 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | Jan | 2021
 | Agent 18 | 0 | 14 | 129 | 2021-01-04 00:00:00 | 2 | 16:03:40 | 1 | 9 | 9 | 9 | 0 | 00:10:26 | 00:05:41 | 01:15:20 | 00:45:18 | 00:00:06 | 0.939 | Jan | 2021
 | Agent 19 | 0 | 1 | 12 | 2021-01-04 00:00:00 | 2 | 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | Jan | 2021
 | Agent 20 | 2 | 25 | 189 | 2021-01-04 00:00:00 | 2 | 1 day, 11:14:23 | 1 | 17 | 12 | 12 | 5 | 01:01:11 | 00:57:08 | 01:24:45 | 00:36:29 | 00:00:07 | 0.7004 | Jan | 2021
 | Agent 21 | 0 | 1 | 10 | 2021-01-04 00:00:00 | 2 | 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | Jan | 2021
 | Agent 22 | 0 | 10 | 95 | 2021-01-04 00:00:00 | 2 | 00:09:22 | 0 | 1 | 0 | 0 | 1 | 00:00:00 | 00:00:00 | 00:09:17 | 00:00:03 | 00:00:00 |  | Jan | 2021
 | Agent 23 | 0 | 3 | 77 | 2021-01-04 00:00:00 | 2 | 14:41:06 | 1 | 20 | 15 | 15 | 5 | 00:32:34 | 00:04:23 | 01:16:12 | 00:41:12 | 00:00:06 | 0.813 | Jan | 2021
 | Agent 24 | 0 | 4 | 53 | 2021-01-04 00:00:00 | 2 | 10:03:05 | 0.9167 | 12 | 12 | 11 | 1 | 00:00:00 | 00:12:11 | 01:08:47 | 00:23:32 | 00:00:05 |  | Jan | 2021
 | Agent 25 | 1 | 41 | 139 | 2021-01-04 00:00:00 | 2 | 1 day, 16:52:47 | 1 | 25 | 24 | 23 | 2 | 00:30:58 | 00:20:09 | 02:41:39 | 03:56:17 | 00:00:10 | 0.9222 | Jan | 2021
 | Agent 26 | 0 | 0 | 8 | 2021-01-04 00:00:00 | 2 | 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | Jan | 2021
 | Agent 27 | 0 | 0 | 9 | 2021-01-04 00:00:00 | 2 | 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | Jan | 2021
 | Agent 28 | 1 | 17 | 174 | 2021-01-04 00:00:00 | 2 | 1 day, 9:43:20 | 1 | 23 | 22 | 22 | 1 | 00:17:32 | 01:04:44 | 02:19:35 | 00:37:44 | 00:00:06 | 0.7553 | Jan | 2021
 | Agent 29 | 0 | 5 | 38 | 2021-01-04 00:00:00 | 2 | 14:34:52 | 1 | 14 | 14 | 14 | 0 | 00:59:48 | 01:24:25 | 01:31:45 | 01:53:03 | 00:00:05 | 0.6265 | Jan | 2021
 | Agent 30 | 0 | 6 | 54 | 2021-01-04 00:00:00 | 2 | 19:18:02 | 1 | 15 | 14 | 14 | 1 | 00:08:41 | 00:34:51 | 02:08:58 | 00:23:16 | 00:00:06 | 0.8695 | Jan | 2021
 | Agent 31 | 1 | 36 | 193 | 2021-01-04 00:00:00 | 2 | 1 day, 8:16:36 | 0.92 | 23 | 25 | 23 | 0 | 02:09:08 | 02:40:02 | 02:27:48 | 01:31:06 | 00:00:09 | 0.6415 | Jan | 2021
 | Agent 32 | 0 | 21 | 151 | 2021-01-04 00:00:00 | 2 | 1 day, 7:08:07 | 0.9643 | 27 | 28 | 27 | 0 | 00:39:33 | 00:55:58 | 01:38:25 | 02:03:57 | 00:00:04 | 0.5886 | Jan | 2021
 | Agent 33 | 2 | 20 | 129 | 2021-01-04 00:00:00 | 2 | 1 day, 14:05:12 | 0.8 | 27 | 35 | 27 | 0 | 00:00:00 | 00:05:25 | 04:10:20 | 01:15:38 | 00:00:12 | 0.8762 | Jan | 2021