Spreadsheet: 143577d1330464993-pulling-information-from-several-sheets-depending-on-criteria-outageoverview
Sheet: OverView

 | Display all instances where each row in USA.D = open
 | Open USA Outages :
 | Date | Service Center Ticket | Owner | Description
 | Date from row in USA tab where D in row = open | Service Center Ticket from row in USA tab where D in row = open | Owner from row in USA tab where D in row = open | Description from row in USA tab where D in row = open
 | Date from row in USA tab where D in row = open | Service Center Ticket from row in USA tab where D in row = open | Owner from row in USA tab where D in row = open | Description from row in USA tab where D in row = open
 | Date from row in USA tab where D in row = open | Service Center Ticket from row in USA tab where D in row = open | Owner from row in USA tab where D in row = open | Description from row in USA tab where D in row = open
 | Date from row in USA tab where D in row = open | Service Center Ticket from row in USA tab where D in row = open | Owner from row in USA tab where D in row = open | Description from row in USA tab where D in row = open
 | Date from row in USA tab where D in row = open | Service Center Ticket from row in USA tab where D in row = open | Owner from row in USA tab where D in row = open | Description from row in USA tab where D in row = open
 | Date from row in USA tab where D in row = open | Service Center Ticket from row in USA tab where D in row = open | Owner from row in USA tab where D in row = open | Description from row in USA tab where D in row = open
 | Date from row in USA tab where D in row = open | Service Center Ticket from row in USA tab where D in row = open | Owner from row in USA tab where D in row = open | Description from row in USA tab where D in row = open
 | Date from row in USA tab where D in row = open | Service Center Ticket from row in USA tab where D in row = open | Owner from row in USA tab where D in row = open | Description from row in USA tab where D in row = open
 | Open UK Outages :
 | Date | Service Center Ticket | Owner | Description
 | Date from row in UK tab where D in row = open | Service Center Ticket from row in UK tab where D in row = open | Owner from row in UK tab where D in row = open | Description from row in UK tab where D in row = open
 | Date from row in UK tab where D in row = open | Service Center Ticket from row in UK tab where D in row = open | Owner from row in UK tab where D in row = open | Description from row in UK tab where D in row = open
 | Date from row in UK tab where D in row = open | Service Center Ticket from row in UK tab where D in row = open | Owner from row in UK tab where D in row = open | Description from row in UK tab where D in row = open
 | Date from row in UK tab where D in row = open | Service Center Ticket from row in UK tab where D in row = open | Owner from row in UK tab where D in row = open | Description from row in UK tab where D in row = open
 | Date from row in UK tab where D in row = open | Service Center Ticket from row in UK tab where D in row = open | Owner from row in UK tab where D in row = open | Description from row in UK tab where D in row = open
 | Date from row in UK tab where D in row = open | Service Center Ticket from row in UK tab where D in row = open | Owner from row in UK tab where D in row = open | Description from row in UK tab where D in row = open
 | Date from row in UK tab where D in row = open | Service Center Ticket from row in UK tab where D in row = open | Owner from row in UK tab where D in row = open | Description from row in UK tab where D in row = open
 | Date from row in UK tab where D in row = open | Service Center Ticket from row in UK tab where D in row = open | Owner from row in UK tab where D in row = open | Description from row in UK tab where D in row = open