curiouscoder
New Member
- Joined
- Jun 24, 2022
- Messages
- 31
- Office Version
- 365
- Platform
- Windows
getting REF! errors in customerID column
customer ID formula
cell row formula =
in this table
it is being referenced off this table
any help would be great because i dont know how to adjust my formula
customer ID formula
Excel Formula:
=INDEX(Table1[Customer ID],[@[Cell Row]])
Excel Formula:
=IFERROR(SUBSTITUTE(SUBSTITUTE([@[Cell Changed]],"H",""),"$",""),[@[Cell Changed]])
Date + Time | Change type | Cell Changed | Old Status | New Status | Customer ID | Cell Row | Date | Time |
29/06/2022 17:35 | Cell Change | $H$19 | 4 | 1 - Assigned | J19 | 19 | 29/06/2022 | 17:35 |
29/06/2022 17:35 | Cell Change | $H$19 | 4 | 2 - In Progress | J19 | 19 | 29/06/2022 | 17:35 |
29/06/2022 17:36 | Cell Change | $H$19 | 2 - In Progress | 3 - Escalated Pre CC | J19 | 19 | 29/06/2022 | 17:36 |
29/06/2022 17:36 | Cell Change | $H$19 | 2 - In Progress | 4 - Sent for Initial Check | J19 | 19 | 29/06/2022 | 17:36 |
29/06/2022 17:36 | Cell Change | $H$19 | 2 - In Progress | 5 - Returned from Initial Check | J19 | 19 | 29/06/2022 | 17:36 |
29/06/2022 17:36 | Cell Change | $H$19 | 2 - In Progress | 6 - Sent for CC | J19 | 19 | 29/06/2022 | 17:36 |
29/06/2022 17:36 | Cell Change | $H$19 | 2 - In Progress | 7 – Request for more info from CC | J19 | 19 | 29/06/2022 | 17:36 |
29/06/2022 17:36 | Cell Change | $H$19 | 2 - In Progress | 8 – Customer response received from CC | J19 | 19 | 29/06/2022 | 17:36 |
29/06/2022 17:36 | Cell Change | $H$19 | 2 - In Progress | 8i - Escalated Post CC | J19 | 19 | 29/06/2022 | 17:36 |
29/06/2022 17:36 | Cell Change | $H$19 | 2 - In Progress | 9 - Uplift in Progress | J19 | 19 | 29/06/2022 | 17:36 |
29/06/2022 17:36 | Cell Change | $H$19 | 2 - In Progress | 10 - Sent for QC | J19 | 19 | 29/06/2022 | 17:36 |
29/06/2022 17:37 | Cell Change | $H$19 | 2 - In Progress | 11 - Returned from QC | J19 | 19 | 29/06/2022 | 17:37 |
29/06/2022 17:37 | Cell Change | $H$19 | 2 - In Progress | 12 - Sent for QC2 | J19 | 19 | 29/06/2022 | 17:37 |
29/06/2022 17:37 | Cell Change | $H$19 | 2 - In Progress | 13 – Final uplift complete | J19 | 19 | 29/06/2022 | 17:37 |
29/06/2022 17:37 | Cell Change | $H$19 | 2 - In Progress | 14 – Awaiting GWS | J19 | 19 | 29/06/2022 | 17:37 |
29/06/2022 17:37 | Cell Change | $H$19 | 2 - In Progress | 15a - CD: FCRP R&R | J19 | 19 | 29/06/2022 | 17:37 |
29/06/2022 17:37 | Cell Change | $H$19 | 2 - In Progress | 15b - CD: FCRP Exit | J19 | 19 | 29/06/2022 | 17:37 |
29/06/2022 17:37 | Cell Change | $H$19 | 2 - In Progress | 15c - CD: Non-responder exit | J19 | 19 | 29/06/2022 | 17:37 |
29/06/2022 17:37 | Cell Change | $H$19 | 2 - In Progress | 15d - CD: R&R Local | J19 | 19 | 29/06/2022 | 17:37 |
29/06/2022 17:37 | Cell Change | $H$19 | 2 - In Progress | 15e - CD: Downgraded | J19 | 19 | 29/06/2022 | 17:37 |
29/06/2022 17:37 | Cell Change | $H$19 | 2 - In Progress | 15f - CD: Descoped | J19 | 19 | 29/06/2022 | 17:37 |
29/06/2022 17:37 | Cell Change | $H$19 | 2 - In Progress | 16 – Alert closed/ updated | J19 | 19 | 29/06/2022 | 17:37 |
29/06/2022 17:38 | Cell Change | $H$19 | 16 – Alert closed/ updated | 1 - Assigned | J19 | 19 | 29/06/2022 | 17:38 |
29/06/2022 17:40 | Cell Change | $H$20 | 5 | 8i - Escalated Post CC | J20 | 20 | 29/06/2022 | 17:40 |
29/06/2022 17:40 | Cell Change | $H$20 | 5 | 10 - Sent for QC | J20 | 20 | 29/06/2022 | 17:40 |
29/06/2022 17:41 | Cell Change | $H$21 | 5 | 8i - Escalated Post CC | J21 | 21 | 29/06/2022 | 17:41 |
29/06/2022 17:47 | Cell Change | $H$22 | 1 | 16 – Alert closed/ updated | J22 | 22 | 29/06/2022 | 17:47 |
29/06/2022 17:47 | Cell Change | $H$22 | 1 | 15f - CD: Descoped | J22 | 22 | 29/06/2022 | 17:47 |
29/06/2022 17:47 | Cell Change | $H$22 | 1 | 15e - CD: Downgraded | J22 | 22 | 29/06/2022 | 17:47 |
29/06/2022 17:47 | Cell Change | $H$22 | 1 | 15d - CD: R&R Local | J22 | 22 | 29/06/2022 | 17:47 |
29/06/2022 17:47 | Cell Change | $H$22 | 1 | 15c - CD: Non-responder exit | J22 | 22 | 29/06/2022 | 17:47 |
29/06/2022 17:47 | Cell Change | $H$22 | 1 | 15b - CD: FCRP Exit | J22 | 22 | 29/06/2022 | 17:47 |
29/06/2022 17:47 | Cell Change | $H$22 | 1 | 15a - CD: FCRP R&R | J22 | 22 | 29/06/2022 | 17:47 |
29/06/2022 17:47 | Cell Change | $H$22 | 1 | 14 – Awaiting GWS | J22 | 22 | 29/06/2022 | 17:47 |
30/06/2022 09:09 | Cell Change | $H$3 | 1 - Assigned | J3 | 3 | 30/06/2022 | 09:09 | |
30/06/2022 09:09 | Cell Change | $H$3 | 2 - In Progress | J3 | 3 | 30/06/2022 | 09:09 | |
30/06/2022 09:09 | Cell Change | $H$5 | 1 - Assigned | J5 | 5 | 30/06/2022 | 09:09 | |
30/06/2022 09:21 | Cell Change | $H$7 | 1 - Assigned | J7 | 7 | 30/06/2022 | 09:21 | |
30/06/2022 12:04 | Cell Change | $H$3 | 1 - Assigned | J3 | 3 | 30/06/2022 | 12:04 | |
30/06/2022 12:42 | Cell Change | $H$3 | 1 - Assigned | J3 | 3 | 30/06/2022 | 12:42 | |
30/06/2022 12:42 | Cell Change | $H$6 | 1 - Assigned | J6 | 6 | 30/06/2022 | 12:42 | |
30/06/2022 12:42 | Cell Change | $H$9 | 1 - Assigned | J9 | 9 | 30/06/2022 | 12:42 | |
30/06/2022 12:43 | Cell Change | $H$5 | 1 - Assigned | J5 | 5 | 30/06/2022 | 12:43 | |
30/06/2022 12:44 | Cell Change | $H$7 | 1 - Assigned | J7 | 7 | 30/06/2022 | 12:44 | |
30/06/2022 12:44 | Cell Change | $H$3 | 1 - Assigned | J3 | 3 | 30/06/2022 | 12:44 | |
30/06/2022 12:44 | Cell Change | $H$3 | 2 - In Progress | J3 | 3 | 30/06/2022 | 12:44 | |
30/06/2022 12:44 | Cell Change | $H$5 | 1 - Assigned | J5 | 5 | 30/06/2022 | 12:44 | |
30/06/2022 12:45 | Cell Change | $H$5 | 2 - In Progress | J5 | 5 | 30/06/2022 | 12:45 | |
30/06/2022 12:50 | Cell Change | $H$3 | 1 - Assigned | J3 | 3 | 30/06/2022 | 12:50 | |
30/06/2022 12:50 | Cell Change | $H$4 | 1 - Assigned | J4 | 4 | 30/06/2022 | 12:50 | |
30/06/2022 12:50 | Cell Change | $H$3 | 1 - Assigned | 2 - In Progress | J3 | 3 | 30/06/2022 | 12:50 |
30/06/2022 12:50 | Cell Change | $H$4 | 1 - Assigned | 2 - In Progress | J4 | 4 | 30/06/2022 | 12:50 |
30/06/2022 12:51 | Cell Change | $H$4 | 1 - Assigned | 3 - Escalated Pre CC | J4 | 4 | 30/06/2022 | 12:51 |
30/06/2022 12:51 | Cell Change | $H$3 | 2 - In Progress | 4 - Sent for Initial Check | J3 | 3 | 30/06/2022 | 12:51 |
30/06/2022 12:51 | Cell Change | $H$4 | 3 - Escalated Pre CC | 5 - Returned from Initial Check | J4 | 4 | 30/06/2022 | 12:51 |
30/06/2022 13:09 | Cell Change | $H$3 | 1 - Assigned | J3 | 3 | 30/06/2022 | 13:09 | |
30/06/2022 13:09 | Cell Change | $H$3 | 2 - In Progress | J3 | 3 | 30/06/2022 | 13:09 | |
30/06/2022 13:09 | Cell Change | $H$3 | 3 - Escalated Pre CC | J3 | 3 | 30/06/2022 | 13:09 | |
30/06/2022 13:09 | Cell Change | $H$3 | 4 - Sent for Initial Check | J3 | 3 | 30/06/2022 | 13:09 | |
30/06/2022 13:09 | Cell Change | $H$3 | 5 - Returned from Initial Check | J3 | 3 | 30/06/2022 | 13:09 | |
30/06/2022 13:09 | Cell Change | $H$3 | 6 - Sent for CC | J3 | 3 | 30/06/2022 | 13:09 | |
30/06/2022 13:09 | Cell Change | $H$3 | 7 – Request for more info from CC | J3 | 3 | 30/06/2022 | 13:09 | |
30/06/2022 13:09 | Cell Change | $H$3 | 8 – Customer response received from CC | J3 | 3 | 30/06/2022 | 13:09 | |
30/06/2022 13:09 | Cell Change | $H$3 | 8i - Escalated Post CC | J3 | 3 | 30/06/2022 | 13:09 | |
30/06/2022 13:09 | Cell Change | $H$3 | 9 - Uplift in Progress | J3 | 3 | 30/06/2022 | 13:09 | |
30/06/2022 13:09 | Cell Change | $H$3 | 10 - Sent for QC | J3 | 3 | 30/06/2022 | 13:09 | |
30/06/2022 13:09 | Cell Change | $H$3 | 11 - Returned from QC | J3 | 3 | 30/06/2022 | 13:09 | |
30/06/2022 13:09 | Cell Change | $H$3 | 12 - Sent for QC2 | J3 | 3 | 30/06/2022 | 13:09 | |
30/06/2022 13:10 | Cell Change | $H$3 | 13 – Final uplift complete | J3 | 3 | 30/06/2022 | 13:10 | |
30/06/2022 13:10 | Cell Change | $H$3 | 14 – Awaiting GWS | J3 | 3 | 30/06/2022 | 13:10 | |
30/06/2022 13:10 | Cell Change | $H$3 | 15a - CD: FCRP R&R | J3 | 3 | 30/06/2022 | 13:10 | |
30/06/2022 13:10 | Cell Change | $H$3 | 15b - CD: FCRP Exit | J3 | 3 | 30/06/2022 | 13:10 | |
30/06/2022 13:10 | Cell Change | $H$3 | 15c - CD: Non-responder exit | J3 | 3 | 30/06/2022 | 13:10 | |
30/06/2022 13:10 | Cell Change | $H$3 | 15d - CD: R&R Local | J3 | 3 | 30/06/2022 | 13:10 | |
30/06/2022 13:10 | Cell Change | $H$3 | 15e - CD: Downgraded | J3 | 3 | 30/06/2022 | 13:10 | |
30/06/2022 13:10 | Cell Change | $H$3 | 15f - CD: Descoped | J3 | 3 | 30/06/2022 | 13:10 | |
30/06/2022 13:10 | Cell Change | $H$3 | 16 – Alert closed/ updated | J3 | 3 | 30/06/2022 | 13:10 | |
30/06/2022 13:38 | Cell Change | $H$3 | 1 - Assigned | J3 | 3 | 30/06/2022 | 13:38 | |
30/06/2022 13:38 | Cell Change | $H$8 | 1 - Assigned | J8 | 8 | 30/06/2022 | 13:38 | |
30/06/2022 13:38 | Cell Change | $H$2 | Status | Column1 | J2 | 2 | 30/06/2022 | 13:38 |
30/06/2022 13:38 | Cell Change | $H$2 | Status | Column1 | J2 | 2 | 30/06/2022 | 13:38 |
30/06/2022 13:38 | Cell Change | $H$2 | Status | Status | J2 | 2 | 30/06/2022 | 13:38 |
30/06/2022 13:38 | Cell Change | $H$22 | 1 - Assigned | J22 | 22 | 30/06/2022 | 13:38 | |
30/06/2022 13:39 | Cell Change | $H$21 | 1 - Assigned | J21 | 21 | 30/06/2022 | 13:39 | |
30/06/2022 15:02 | Cell Change | $H$3 | 1 - Assigned | J3 | 3 | 30/06/2022 | 15:02 | |
30/06/2022 15:02 | Cell Change | $H$3 | 2 - In Progress | J3 | 3 | 30/06/2022 | 15:02 | |
30/06/2022 16:28 | Cell Change | $H$26 | 1 - Assigned | J26 | 26 | 30/06/2022 | 16:28 | |
30/06/2022 16:29 | Cell Change | $H$3 | 1 - Assigned | J3 | 3 | 30/06/2022 | 16:29 | |
30/06/2022 16:29 | Cell Change | $H$3 | 2 - In Progress | J3 | 3 | 30/06/2022 | 16:29 | |
30/06/2022 16:34 | Cell Change | $H$4 | 1 - Assigned | J4 | 4 | 30/06/2022 | 16:34 | |
30/06/2022 16:35 | Cell Change | $H$5 | 1 - Assigned | J5 | 5 | 30/06/2022 | 16:35 | |
30/06/2022 16:35 | Cell Change | $H$5 | 2 - In Progress | J5 | 5 | 30/06/2022 | 16:35 | |
30/06/2022 16:39 | Cell Change | $H$6 | 1 - Assigned | J6 | 6 | 30/06/2022 | 16:39 | |
30/06/2022 16:41 | Cell Change | $H$27 | 1 - Assigned | J27 | 27 | 30/06/2022 | 16:41 | |
30/06/2022 16:52 | Cell Change | $H$28 | 1 - Assigned | #REF! | 28 | 30/06/2022 | 16:52 | |
30/06/2022 16:55 | Cell Change | $H$3 | 2 - In Progress | 2 - In Progress | J3 | 3 | 30/06/2022 | 16:55 |
30/06/2022 16:55 | Cell Change | $H$3 | 2 - In Progress | 1 - Assigned | J3 | 3 | 30/06/2022 | 16:55 |
30/06/2022 16:55 | Cell Change | $H$3 | 2 - In Progress | 2 - In Progress | J3 | 3 | 30/06/2022 | 16:55 |
30/06/2022 16:55 | Cell Change | $H$3 | 2 - In Progress | 3 - Escalated Pre CC | J3 | 3 | 30/06/2022 | 16:55 |
30/06/2022 17:16 | Cell Change | $H$29 | 1 - Assigned | #REF! | 29 | 30/06/2022 | 17:16 | |
30/06/2022 18:19 | Cell Change | $H$3 | 1 - Assigned | J3 | 3 | 30/06/2022 | 18:19 |
it is being referenced off this table
Alert ID | Customer ID | Entity Type | Status | Pod (Team) | Reviewer | Assigned | In Progress |
J1 | 1 - Assigned | #N/A | |||||
J2 | |||||||
J3 | |||||||
J4 | |||||||
J5 | |||||||
J6 | |||||||
J7 | |||||||
J8 | |||||||
J9 | |||||||
J10 | |||||||
J11 | |||||||
J12 | |||||||
J13 | |||||||
J14 | |||||||
J15 | |||||||
J16 | |||||||
J17 | |||||||
J18 | |||||||
J19 | |||||||
J20 | |||||||
J21 | 1 - Assigned | 30/06/2022 13:39:24 | |||||
J22 | |||||||
J23 | 1 - Assigned | #N/A | |||||
J24 | 1 - Assigned | #N/A | |||||
J25 | 1 - Assigned | #N/A | |||||
J26 | 1 - Assigned | 30/06/2022 16:28:50 | |||||
J27 | 1 - Assigned | 30/06/2022 16:41:33 |
any help would be great because i dont know how to adjust my formula