Spreadsheet: 883483d1732100473-pivot-table-doesnt-recognise-dates-generated-by-a-formula-formula_test-version-3
Sheet: No access tracker

PROPERTY/TENANT DETAILS |  |  |  |  |  | Survey completed |  | APPOINTMENT BOOKED |  |  |  |  |  |  | LETTER 1 |  |  |  |  |  |  |  | LETTER 2 |  |  |  |  |  | LETTER 3 |  |  |  |  |  |  |  | LEGAL
Survey type | Area | Full Address | [NAME] | Phone number | Date helper (hidden) | Survey completed date | Survey AMO | 1st call date | Confirm letter date | No of times appt date changed | Letter 1 alert | Appointment date | AMO | HCS completed? | 2nd call reminder date | 2nd call actual date | Letter 1 confirm letter date | Check 2nd call date (hidden) | Letter 1 suggested appointment date | Letter 1 actual appointment date | L1 AMO | Letter 1 HCS completed? | Letter 2 suggested date | Letter 2 actual date | Letter 2 suggested appointment date | Letter 2 actual appointment date | [NAME] | Letter 2 HCS completed? | Letter 3 suggested date | Letter 3 actual date | Check 3rd appointment (hidden) | Letter 3 suggested appointment date | Letter 3 actual appointment date | L3 AMO | Letter 3 HCS completed? | Survey done (hidden) | Refer to legal date | Referred date
HCS | Area 1 | 1 High Street | Mr [NAME] | 01234 567890 |  | 2024-10-14 00:00:00 |  | 2024-09-30 00:00:00 | 2024-09-30 00:00:00 |  |  | 2024-10-14 00:00:00 | [NAME] | Yes
HCS | Area 2 | 2 High Street | Mr [NAME] | 01234 567890 |  | 2024-10-14 00:00:00 |  | 2024-09-30 00:00:00 | 2024-09-30 00:00:00 |  |  | 2024-10-14 00:00:00 | [NAME] | Yes
HCS | Area 2 | 3 High Street | [NAME] | 01234 567890 |  | 2024-10-14 00:00:00 |  | 2024-09-30 00:00:00 | 2024-09-30 00:00:00 |  |  | 2024-10-14 00:00:00 | Lauren | Yes
HCS | Area 7 | 4 High Street | Mr Croot | 01234 567890 |  | 2024-10-20 00:00:00 |  | 2024-09-30 00:00:00 | 2024-09-30 00:00:00 |  |  | 2024-10-17 00:00:00 |  | No |  | 2024-10-19 00:00:00 |  |  |  | 2024-10-20 00:00:00 | Lauren | Yes
HCS | Area 4 | 5 High Street | Miss [NAME] | 01234 567890 |  | 2024-11-30 00:00:00 |  | 2024-09-30 00:00:00 | 2024-09-30 00:00:00 |  |  | 2024-10-17 00:00:00 |  | No |  | 2024-10-19 00:00:00 |  |  |  | 2024-10-20 00:00:00 |  | No |  | 2024-11-29 00:00:00 |  | 2024-11-30 00:00:00 | [NAME] | Yes
HCS | Area 2 | 1 Main Street | Miss [NAME] | 01234 567890 |  | 2025-01-27 00:00:00 |  | 2024-09-30 00:00:00 | 2024-09-30 00:00:00 |  |  | 2024-10-19 00:00:00 |  | No |  | 2024-10-22 00:00:00 |  |  |  | 2024-11-05 00:00:00 |  | No |  | 2024-12-02 00:00:00 |  | 2024-12-16 00:00:00 |  | No |  | 2025-01-13 00:00:00 |  |  | 2025-01-27 00:00:00 | [NAME] | Yes
HCS | Area 2 | 2 Main Street | [NAME] | No number |  | 2024-10-19 00:00:00 |  | 2024-09-30 00:00:00 | 2024-09-30 00:00:00 |  |  | 2024-10-19 00:00:00 | Lauren | Yes
EPC | Area 3 | 6 High Street |  |  |  | 2024-11-19 00:00:00 |  | 2024-10-12 00:00:00 | 2024-10-12 00:00:00 |  |  | 2024-11-19 00:00:00 | Lauren | Yes
EPC | Area 6 | 7 High Street |  |  |  | 2024-11-22 00:00:00 |  | 2024-10-12 00:00:00 | 2024-10-12 00:00:00 |  |  | 2024-11-22 00:00:00 | [NAME] | Yes
VOID | Area 8 | 8 High Street |  |  |  |  |  | 2024-10-12 00:00:00 | 2024-10-12 00:00:00 |  |  | 2024-11-14 00:00:00 |  | No
HHSRS | Area 2 | 9 High Street |  |  |  | 2024-10-23 00:00:00 |  | 2024-10-12 00:00:00 | 2024-10-12 00:00:00 |  |  | 2024-10-23 00:00:00 | [NAME] | Yes
DO NOT INPUT BELOW THIS LINE - TAB TO END OF TABLE TO ADD NEW ROWS
 |  |  |  |  |  |  | Row Labels | Count of Survey done (hidden)
 |  |  |  |  |  |  | HCS | 5
 |  |  |  |  |  |  | [NAME] | 1
 |  |  |  |  |  |  | 2024-10-14 00:00:00 | 1
 |  |  |  |  |  |  | Lauren | 3
 |  |  |  |  |  |  | 2024-10-14 00:00:00 | 1
 |  |  |  |  |  |  | 2024-10-19 00:00:00 | 1
 |  |  |  |  |  |  | 2024-10-20 00:00:00 | 1
 |  |  |  |  |  |  | [NAME] | 1
 |  |  |  |  |  |  | 2024-10-14 00:00:00 | 1
 |  |  |  |  |  |  | HHSRS | 1
 |  |  |  |  |  |  | [NAME] | 1
 |  |  |  |  |  |  | 2024-10-23 00:00:00 | 1
 |  |  |  |  |  |  | Grand Total | 6