Spreadsheet: 782010d1653682215-pulling-min-data-from-another-sheet-error-detection-daily-tickets-report-forums-
Sheet: Kentrone

Company | Ticket ID | Customer_ID | Property Name | RoomNo | Tickets Reason | Created On | Total Call | IssueDetails | Ticketstatus | Details |  |  | Created On | Total Call | IssueDetails | Open Level 1 - CallBack/Follow Up |  |  | Created On | Total Call | IssueDetails | Open Level 2 - Escalated to Supervisor |  |  | Created On | Total Call | IssueDetails | Open Level 3 - Client
[NAME] | 71590 | 95331583 | [NAME] (Outsource) | 219 | Cannot Connect, [NAME]) | 2022-05-14 00:00:00 | 2 | 1. [NAME] called in because he cannot access the portal page on any of his devices (iphone and | Open Level 3 - Client | DetailsC |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-05-14 00:00:00 | 2 | 1. [NAME] called in because he cannot access the portal page on any of his devices (iphone and | Open Level 3 - Client
[NAME] | 71692 | 96177506 | Westgate Las Vegas Resort & Casino | 7132-N | Cannot Connect to WiFi(LP) | 2022-05-16 00:00:00 | 5 | 1. [NAME] said that he is having an issue connecting to the Wi-Fi | Open Level 3 - Client | DetailsC |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-05-16 00:00:00 | 5 | 1. [NAME] said that he is having an issue connecting to the Wi-Fi | Open Level 3 - Client
 |  |  |  |  |  |  |  | - Connecting: iPad |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | - Connecting: iPad
 |  |  |  |  |  |  |  | - SSID |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | - SSID
 |  |  |  |  |  |  |  | http://ticket.kentrone.com/Company/company_report.html |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | http://ticket.kentrone.com/Company/company_report.html
[NAME] | 71711 | 65783733 | Vacation Village The Colonies at Williamsburg (Outsource) | 58A | AccessPoint Down (MP) | 2022-05-16 00:00:00 | 2 | 1. [NAME] said that all of his devices get disconnected right away | Open Level 3 - Client | DetailsC |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-05-16 00:00:00 | 2 | 1. [NAME] said that all of his devices get disconnected right away | Open Level 3 - Client
 |  |  |  |  |  |  |  | 2. Accessed ZD |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2. Accessed ZD
 |  |  |  |  |  |  |  | - AP in guest room |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | - AP in guest room
 |  |  |  |  |  |  |  | http://ticket.kentrone.com/Company/company_report.html |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | http://ticket.kentrone.com/Company/company_report.html
[NAME] | 71736 | 96177506 | Westgate Las Vegas Resort & Casino | 22117-N | Cannot Connect, [NAME]) | 2022-05-17 00:00:00 | 1 | 1. [NAME] said that she is having an issue connecting to the Wi-Fi | Open Level 3 - Client | DetailsC |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-05-17 00:00:00 | 1 | 1. [NAME] said that she is having an issue connecting to the Wi-Fi | Open Level 3 - Client
 |  |  |  |  |  |  |  | - Connecting: Windows Laptop and |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | - Connecting: Windows Laptop and
 |  |  |  |  |  |  |  | http://ticket.kentrone.com/Company/company_report.html |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | http://ticket.kentrone.com/Company/company_report.html
[NAME] | 71749 | 65783733 | Vacation Village The Colonies at Williamsburg (Outsource) | 43B | AccessPoint Down (MP) | 2022-05-17 00:00:00 | 1 | 1. [NAME] said that all his device is connected but not today | Open Level 3 - Client | DetailsC |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-05-17 00:00:00 | 1 | 1. [NAME] said that all his device is connected but not today | Open Level 3 - Client
 |  |  |  |  |  |  |  | -3phones and iPad |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -3phones and iPad
 |  |  |  |  |  |  |  | -Guest said that |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -Guest said that
 |  |  |  |  |  |  |  | http://ticket.kentrone.com/Company/company_report.html |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | http://ticket.kentrone.com/Company/company_report.html
[NAME] | 71780 | 75252741 | Vacation Village Parkway Resort (Outsource) | 17 902B | Cannot Connect to WiFi(LP) | 2022-05-18 00:00:00 | 2 | 1. [NAME] said the wifi was working fine yesterday | Open Level 3 - Client | DetailsC |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-05-18 00:00:00 | 2 | 1. [NAME] said the wifi was working fine yesterday | Open Level 3 - Client
 |  |  |  |  |  |  |  | 2. [NAME]'s laptop is connected but no internet |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2. [NAME]'s laptop is connected but no internet
 |  |  |  |  |  |  |  | http://ticket.kentrone.com/Company/company_report.html |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | http://ticket.kentrone.com/Company/company_report.html
[NAME] | 71782 | 45350761 | FantaSea Flagship Resort | 1019 | [NAME] (MP) | 2022-05-18 00:00:00 | 1 | 1. [NAME] said the wifi is very weak and unstable | Open Level 3 - Client | DetailsC |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-05-18 00:00:00 | 1 | 1. [NAME] said the wifi is very weak and unstable | Open Level 3 - Client
 |  |  |  |  |  |  |  | 2. [NAME] can only detect 1 signal bar at the |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2. [NAME] can only detect 1 signal bar at the
 |  |  |  |  |  |  |  | http://ticket.kentrone.com/Company/company_report.html |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | http://ticket.kentrone.com/Company/company_report.html
[NAME] | 71795 | 55451678 | Vacation Village Grandview Hotel (Outsource) | [NAME] | [NAME] (MP) | 2022-05-18 00:00:00 | 1 | 1. [NAME] said that the WiFI is working fine but not today | Open Level 3 - Client | DetailsC |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-05-18 00:00:00 | 1 | 1. [NAME] said that the WiFI is working fine but not today | Open Level 3 - Client
 |  |  |  |  |  |  |  | -Guest said that the WiFI become |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -Guest said that the WiFI become
 |  |  |  |  |  |  |  | http://ticket.kentrone.com/Company/company_report.html |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | http://ticket.kentrone.com/Company/company_report.html