Good Evening,
I have a table that looks like this (It's over 400 rows)
On a different sheet I have another table that looks like this:
What I'm trying to accomplish is to have on a third sheet a table were the tickets displayed will only be the ones from the districts and labels show on the second table so for example it will show the 6 tickets for doors and hardware from District 1 but no doors & hardware tickets for District 2.
I Tried using the Filter Formula but can't get to nest all the criteria, also using the 2nd table is not strictly neccesary since that table is build using the following criteria: If a lebal has more than 5 tickets in the same District is added to the table
thanks
I have a table that looks like this (It's over 400 rows)
ID | Requester | Agent assigned | Store Number | District | Title | Status | Priority | Created on | Updated On | Days Opened up to date | Last Updated (days) | Follow up Notations | Label |
FD20210222366 | Jane Doe | Tom Ruiz | 185 | District 9 | Title 1 | In Progress | Low | 22-Feb-2021 | 8-Mar-2021 | 960 | 946 | Signage | |
FD20210531656 | John Doe | Gerard Gonzalez | 185 | District 9 | Title 2 | In Progress | High | 31-May-2021 | 1-Jun-2021 | 862 | 861 | Other | |
FL20210611028 | Jane Doe | Raul Becks | 6 | District 3 | Title 3 | Reopen | High | 11-Jun-2021 | 14-Feb-2023 | 851 | 238 | Paving | |
FD20210611191 | John Doe | Tom Ruiz | 90 | District 9 | Title 4 | In Progress | Medium | 11-Jun-2021 | 15-Jun-2021 | 851 | 847 | Glass & Windows | |
FL20210917983 | Jane Doe | Gerard Gonzalez | 7 | District 9 | Title 5 | In Progress | Medium | 17-Sep-2021 | 5-Jun-2023 | 753 | 127 | Paving | |
FD20211025668 | John Doe | Raul Becks | 134 | District 6 | Title 6 | In Progress | High | 25-Oct-2021 | 25-Oct-2021 | 715 | 715 | Doors & Hardware | |
FL20211229579 | Jane Doe | Tom Ruiz | 7 | District 9 | Title 7 | In Progress | Medium | 29-Dec-2021 | 10-Jan-2023 | 650 | 273 | Paving | |
FD20220131841 | John Doe | Gerard Gonzalez | 230 | District 15 | Title 8 | In Progress | High | 31-Jan-2022 | 31-Jan-2022 | 617 | 617 | Glass & Windows | |
FD20220217753 | Jane Doe | Raul Becks | 262 | District 12 | Title 9 | Pending Store Response | Medium | 17-Feb-2022 | 10-Jan-2023 | 600 | 273 | Glass & Windows | |
PS20220217591 | John Doe | Tom Ruiz | 4 | District 12 | Title 10 | In Progress | Low | 17-Feb-2022 | 5-Sep-2022 | 600 | 400 | Order Request/Cleaning items | |
FD20220220199 | Jane Doe | Gerard Gonzalez | 4 | District 12 | Title 11 | In Progress | High | 20-Feb-2022 | 6-Jul-2022 | 597 | 461 | Glass & Windows | |
FF20220307978 | John Doe | Raul Becks | 220 | District 14 | Title 12 | In Progress | High | 7-Mar-2022 | 9-Mar-2022 | 582 | 580 | Flooring | |
FE20220331374 | Jane Doe | Tom Ruiz | 115 | District 9 | Title 13 | In Progress | Medium | 31-Mar-2022 | 10-Jan-2023 | 558 | 273 | $3, 810 | Plumbing |
FD20220425563 | John Doe | Gerard Gonzalez | 94 | District 10 | Title 14 | Pending Store Response | Low | 25-Apr-2022 | 28-Jun-2022 | 533 | 469 | S94 | Order Request/Cleaning items |
FS20220510282 | Jane Doe | Raul Becks | 273 | District 14 | Title 15 | In Progress | High | 10-May-2022 | 1-Jul-2022 | 518 | 466 | Signage | |
FE20220624418 | John Doe | Tom Ruiz | 176 | District 17 | Title 16 | In Progress | High | 24-Jun-2022 | 30-Jun-2022 | 473 | 467 | Electrical/Lighting | |
FL20220627118 | Jane Doe | Gerard Gonzalez | 270 | District 14 | Title 17 | In Progress | Low | 27-Jun-2022 | 3-May-2023 | 470 | 160 | Landscaping | |
FF20220630611 | John Doe | Raul Becks | 41 | District 2 | Title 18 | In Progress | High | 30-Jun-2022 | 13-Jul-2022 | 467 | 454 | Doors & Hardware | |
FE20220630899 | Jane Doe | Tom Ruiz | 41 | District 2 | Title 19 | In Progress | High | 30-Jun-2022 | 13-Feb-2023 | 467 | 239 | Electrical/Lighting | |
FD20220707552 | John Doe | Gerard Gonzalez | 76 | District 10 | Title 20 | In Progress | Medium | 7-Jul-2022 | 28-Jul-2022 | 460 | 439 | Electrical/Lighting | |
FE20220716459 | Jane Doe | Raul Becks | 273 | District 14 | Title 21 | In Progress | High | 16-Jul-2022 | 4-Jan-2023 | 451 | 279 | Ask for pictures | Furniture |
FE20220719024 | John Doe | Tom Ruiz | 92 | District 15 | Title 22 | In Progress | Medium | 19-Jul-2022 | 20-Jul-2022 | 448 | 447 | Fire Safety | |
FD20220802444 | Jane Doe | Gerard Gonzalez | 19 | District 1 | Title 23 | In Progress | High | 2-Aug-2022 | 16-Nov-2022 | 434 | 328 | Doors & Hardware | |
FD20220802399 | John Doe | Raul Becks | 31 | District 1 | Title 24 | In Progress | High | 2-Aug-2022 | 5-Aug-2022 | 434 | 431 | Other | |
FF20220802359 | Jane Doe | Tom Ruiz | 31 | District 1 | Title 25 | Reopen | High | 2-August-2022 | 2-October-2023 | 434 | 8 | Flooring | |
On a different sheet I have another table that looks like this:
Key Focus Tickets | |||||||
Doors & Hardware | Electrical/Lighting | Flooring | Glass & Windows | Landscaping | Roof leaks | Signage | |
District 1 | 6 | 5 | 5 | -- | 6 | -- | 8 |
District 2 | -- | 7 | -- | -- | -- | -- | -- |
District 3 | -- | -- | -- | -- | 5 | -- | -- |
District 4 | -- | 5 | -- | -- | -- | -- | -- |
District 6 | 5 | -- | -- | -- | -- | -- | 5 |
District 8 | -- | -- | -- | -- | -- | -- | 5 |
District 9 | -- | -- | -- | -- | -- | 6 | 5 |
District 11 | 6 | -- | -- | -- | -- | -- | -- |
District 15 | -- | -- | -- | 5 | -- | -- | -- |
District 17 | -- | 10 | -- | -- | -- | 6 | 5 |
What I'm trying to accomplish is to have on a third sheet a table were the tickets displayed will only be the ones from the districts and labels show on the second table so for example it will show the 6 tickets for doors and hardware from District 1 but no doors & hardware tickets for District 2.
I Tried using the Filter Formula but can't get to nest all the criteria, also using the 2nd table is not strictly neccesary since that table is build using the following criteria: If a lebal has more than 5 tickets in the same District is added to the table
thanks