Spreadsheet: 814074d1674142602-lookup-repeat-value-in-column-and-calculate-days-between-records-sample3
Sheet: Sheet1

Machine Profile Name | Work Order Number | Appointment Number | Assigned Resource Number | Machine ID | Serial Number | Work Order ID | Work Type: Work Type Name | Work Type Indicator | Work Type: Work Type Name | Service Appointment ID | Service Territory: Name | Service Resource: Name | Travelling Start | Travelling End | Travelling Time (Minutes) | Machine Description | Machine Brand | Machine Type | Machine Installation Date | Actual Start | Created Date & Time | Actual End | Duration in Minutes | Actual Completion Days | Status | Months from Installation Date | Reason For No Intervention | Country | Created Date | Month | Created Date (Formatted) | End Date (Formatted) | Arrive Date (Formatted) | Internal E2E (Working Hours) | Customer E2E (Days) | Internal Response Time (Hours) | Customer Response Time | Repeat after how many days? (days)
sample | sample | sample | sample | sample | MM02867 | sample | UK Repair Medium | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | 16/09/2022 | samples | samples | samples | samples | samples | samples | samples | samples
sample | sample | sample | sample | sample | MM09680 | sample | UK Repair Medium | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | 16/09/2022 | samples | samples | samples | samples | samples | samples | samples | samples
sample | sample | sample | sample | sample | MM07207 | sample | UK Repair Medium | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | 16/09/2022 | samples | samples | samples | samples | samples | samples | samples | samples
sample | sample | sample | sample | sample | LK44163 | sample | UK Repair Medium | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | 16/09/2022 | samples | samples | samples | samples | samples | samples | samples | samples
sample | sample | sample | sample | sample | LK28636 | sample | UK Client Care Low | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | 16/09/2022 | samples | samples | samples | samples | samples | samples | samples | samples
sample | sample | sample | sample | sample | MM07155 | sample | UK Preventative Maintenance Low | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | 16/09/2022 | samples | samples | samples | samples | samples | samples | samples | samples
sample | sample | sample | sample | sample | MM02063 | sample | DE Repair Low | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | 16/09/2022 | samples | samples | samples | samples | samples | samples | samples | samples
sample | sample | sample | sample | sample | LK20455 | sample | FR Repair Medium | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | 16/09/2022 | samples | samples | samples | samples | samples | samples | samples | samples
sample | sample | sample | sample | sample | [PHONE] | sample | DE Revisit Low | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | 16/09/2022 | samples | samples | samples | samples | samples | samples | samples | samples
sample | sample | sample | sample | sample | 21620391 | sample | UK Repair Low XX | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | 16/09/2022 | samples | samples | samples | samples | samples | samples | samples | samples
sample | sample | sample | sample | sample | MM01982-02i4W00000VVG2JQAX | sample | UK Repair Low | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | 16/09/2022 | samples | samples | samples | samples | samples | samples | samples | samples
sample | sample | sample | sample | sample | MM08528 | sample | DE Repair High | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | 16/09/2022 | samples | samples | samples | samples | samples | samples | samples | samples
sample | sample | sample | sample | sample | MM08661 | sample | UK Repair Medium | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | 16/09/2022 | samples | samples | samples | samples | samples | samples | samples | samples
sample | sample | sample | sample | sample | ME02412 | sample | UK Repair High | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | 03/10/2022 | samples | samples | samples | samples | samples | samples | samples | samples
sample | sample | sample | sample | sample | LK27968 | sample | FR Repair Medium | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | 16/09/2022 | samples | samples | samples | samples | samples | samples | samples | samples
sample | sample | sample | sample | sample | L1022462 | sample | UK Repair Medium | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | 03/10/2022 | samples | samples | samples | samples | samples | samples | samples | samples
sample | sample | sample | sample | sample | LK44242 | sample | UK Repair Medium | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | 16/09/2022 | samples | samples | samples | samples | samples | samples | samples | samples
sample | sample | sample | sample | sample | LK37865 | sample | Uk Revisit Medium | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | 03/10/2022 | samples | samples | samples | samples | samples | samples | samples | samples
sample | sample | sample | sample | sample | 73519018 | sample | UK Repair Medium | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | 16/09/2022 | samples | samples | samples | samples | samples | samples | samples | samples
sample | sample | sample | sample | sample | MM03504 | sample | UK Repair Medium | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | 14/09/2022 | samples | samples | samples | samples | samples | samples | samples | samples
sample | sample | sample | sample | sample | MM02939 | sample | UK Repair Medium | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | 16/09/2022 | samples | samples | samples | samples | samples | samples | samples | samples
sample | sample | sample | sample | sample | ME04044 | sample | FR Installation No Priority | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | 16/09/2022 | samples | samples | samples | samples | samples | samples | samples | samples
sample | sample | sample | sample | sample | MM02867 | sample | DE Repair High | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | 05/10/2022 | samples | samples | samples | samples | samples | samples | samples | samples | 41
sample | sample | sample | sample | sample | 21221936 | sample | FR Installation No Priority | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | 16/09/2022 | samples | samples | samples | samples | samples | samples | samples | samples
sample | sample | sample | sample | sample | 453-083328 | sample | UK Preventative Maintenance Medium | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | 16/09/2022 | samples | samples | samples | samples | samples | samples | samples | samples
sample | sample | sample | sample | sample | K45014837 | sample | DE Repair High | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | [NAME] | samples | samples | samples | samples | samples | samples | samples | samples
sample | sample | sample | sample | sample | [NAME] | sample | FR Repair Medium | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | 16/09/2022 | samples | samples | samples | samples | samples | samples | samples | samples
sample | sample | sample | sample | sample | K4509006 | sample | DE Repair Low | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | 16/09/2022 | samples | samples | samples | samples | samples | samples | samples | samples
sample | sample | sample | sample | sample | MM01764 | sample | UK Repair Medium | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | 16/09/2022 | samples | samples | samples | samples | samples | samples | samples | samples
sample | sample | sample | sample | sample | MM00905 | sample | UK Preventative Maintenance Medium | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | 16/09/2022 | samples | samples | samples | samples | samples | samples | samples | samples
sample | sample | sample | sample | sample | 453-083610 | sample | UK Preventative Maintenance Medium | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | 16/09/2022 | samples | samples | samples | samples | samples | samples | samples | samples
sample | sample | sample | sample | sample | K4507256 | sample | DE Repair Low | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | 16/09/2022 | samples | samples | samples | samples | samples | samples | samples | samples
sample | sample | sample | sample | sample | K45012864 | sample | DE Repair High | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | 16/09/2022 | samples | samples | samples | samples | samples | samples | samples | samples
sample | sample | sample | sample | sample | LK53334 | sample | UK Repair Medium | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | 16/09/2022 | samples | samples | samples | samples | samples | samples | samples | samples
sample | sample | sample | sample | sample | [PHONE] | sample | DE Revisit Low | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | samples | 16/09/2022 | samples | samples | samples | samples | samples | samples | samples | samples