Spreadsheet: 833030d1686740347-problem-with-countif-book2
Sheet: H1 2023

On-boarding Metrics 2023
Working sheet
 | How to use this template
 | Copy and create another version of this sheet.
 | Change the title to the correct year and month.
 | Paste in data from everyone's reports into the table.
 | Status total: Total approved, complete, and pending submission to calculate the Finalised total.
 | Status total: Calculate (%) against total assignments.
 | Worktype: Select whole table. Go to [NAME] and create a pie chart.
 | Day/No.: Select whole table. Go into [NAME] and create line graph.
 | Appian ID | Assignment Title | Work Type | Status | Created Date |  | Total Assignments |  |  | Day | No.
 |  |  |  | Complete | 2023-02-01 11:34:50 |  |  |  |  | 2023-02-01 00:00:00
 |  |  |  | Complete | 2023-02-01 12:28:51 |  | Status Totals | No. | % Total | 2023-02-02 00:00:00
 |  |  |  | Abort | 2023-02-01 16:31:36 |  |  |  |  | 2023-02-03 00:00:00
 |  |  |  | Complete | 2023-02-02 11:19:04 |  |  |  |  | 2023-02-04 00:00:00
 |  |  |  | Complete | 2023-02-02 16:30:20 |  |  |  |  | 2023-02-05 00:00:00
 |  |  |  | Complete | 2023-02-03 09:00:11 |  |  |  |  | 2023-02-06 00:00:00
 |  |  |  | Complete | 2023-02-03 09:41:02 |  |  |  |  | 2023-02-07 00:00:00
 |  |  |  | Abort | 2023-02-06 10:10:42 |  |  |  |  | 2023-02-08 00:00:00
 |  |  |  | Complete | 2023-02-06 10:28:38 |  |  |  |  | 2023-02-09 00:00:00
 |  |  |  | Complete | 2023-02-06 10:52:30 |  | Worktype | No. | % Total | 2023-02-10 00:00:00
 |  |  |  | In-Progress | 2023-02-06 11:23:38 |  |  |  |  | 2023-02-11 00:00:00
 |  |  |  | Complete | 2023-02-06 12:02:59 |  |  |  |  | 2023-02-12 00:00:00
 |  |  |  | Complete | 2023-02-06 12:04:24 |  |  |  |  | 2023-02-13 00:00:00
 |  |  |  | Abort | 2023-02-07 09:14:43 |  |  |  |  | 2023-02-14 00:00:00
 |  |  |  | Complete | 2023-02-07 09:44:28 |  |  |  |  | 2023-02-15 00:00:00
 |  |  |  | Abort | 2023-02-08 10:08:53 |  |  |  |  | 2023-02-16 00:00:00
 |  |  |  | Complete | 2023-02-08 15:36:28 |  |  |  |  | 2023-02-17 00:00:00
 |  |  |  | Abort | 2023-02-09 08:33:10 |  |  |  |  | 2023-02-18 00:00:00
 |  |  |  | Abort | 2023-02-09 09:21:57 |  |  |  |  | 2023-02-19 00:00:00
 |  |  |  | Complete | 2023-02-09 10:00:28 |  |  |  |  | 2023-02-20 00:00:00
 |  |  |  | Complete | 2023-02-09 11:34:01 |  |  |  |  | 2023-02-21 00:00:00
 |  |  |  | Abort | 2023-02-09 15:09:46 |  |  |  |  | 2023-02-22 00:00:00
 |  |  |  | Abort | 2023-02-09 15:41:50 |  |  |  |  | 2023-02-23 00:00:00
 |  |  |  | Abort | 2023-02-09 16:48:52 |  |  |  |  | 2023-02-24 00:00:00
 |  |  |  | In-Progress | 2023-02-09 16:52:05 |  |  |  |  | 2023-02-25 00:00:00
 |  |  |  | Complete | 2023-02-09 17:06:02 |  |  |  |  | 2023-02-26 00:00:00
 |  |  |  | Complete | 2023-02-10 08:56:55 |  |  |  |  | 2023-02-27 00:00:00
 |  |  |  | Complete | 2023-02-10 12:27:56 |  |  |  |  | 2023-02-28 00:00:00
 |  |  |  | Abort | 2023-02-10 12:31:19
 |  |  |  | Abort | 2023-02-10 12:38:05
 |  |  |  | Abort | 2023-02-10 12:52:53
 |  |  |  | Abort | 2023-02-10 13:09:52
 |  |  |  | Abort | 2023-02-10 16:55:18
 |  |  |  | Complete | 2023-02-13 09:42:24
 |  |  |  | Complete | 2023-02-13 11:48:53
 |  |  |  | Complete | 2023-02-13 14:15:43
 |  |  |  | Complete | 2023-02-14 09:38:33
 |  |  |  | Abort | 2023-02-14 14:51:59
 |  |  |  | Complete | 2023-02-14 16:07:11
 |  |  |  | Complete | 2023-02-14 16:42:56
 |  |  |  | In-Progress | 2023-02-14 16:53:32
 |  |  |  | Complete | 2023-02-15 11:43:13
 |  |  |  | Complete | 2023-02-15 14:56:14
 |  |  |  | Complete | 2023-02-15 17:59:08
 |  |  |  | Complete | 2023-02-16 09:06:57
 |  |  |  | Complete | 2023-02-16 12:51:33
 |  |  |  | Complete | 2023-02-16 14:44:22
 |  |  |  | Abort | 2023-02-16 17:25:03
 |  |  |  | Complete | 2023-02-17 09:17:23
 |  |  |  | Complete | 2023-02-17 09:39:15
 |  |  |  | Abort | 2023-02-17 09:44:24
 |  |  |  | In-Progress | 2023-02-17 11:47:04
 |  |  |  | Abort | 2023-02-20 07:43:52
 |  |  |  | Abort | 2023-02-20 10:30:35
 |  |  |  | Complete | 2023-02-20 14:33:41
 |  |  |  | Abort | 2023-02-21 12:12:27
 |  |  |  | In-Progress | 2023-02-21 12:39:28
 |  |  |  | Complete | 2023-02-22 12:32:26
 |  |  |  | Complete | 2023-02-23 08:48:46
 |  |  |  | Complete | 2023-02-23 11:21:15
 |  |  |  | Complete | 2023-02-23 14:44:02
 |  |  |  | Complete | 2023-02-24 07:45:50
 |  |  |  | Complete | 2023-02-24 08:38:54
 |  |  |  | In-Progress | 2023-02-24 08:53:47
 |  |  |  | Abort | 2023-02-24 10:47:40
 |  |  |  | Complete | 2023-02-24 11:37:15
 |  |  |  | Complete | 2023-02-27 09:16:20
 |  |  |  | In-Progress | 2023-02-27 12:26:36
 |  |  |  | Complete | 2023-02-27 12:26:58
 |  |  |  | Complete | 2023-02-27 12:43:50
 |  |  |  | Complete | 2023-02-28 09:38:43
 |  |  |  | Complete | 2023-02-28 16:16:25