Spreadsheet: 873507d1720010029-need-help-with-a-textjoin-filter-formula-kansas-scheduler-v4-archive-june-2024
Sheet: Fabric

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Links
 |  |  |  |  |  |  |  |  |  |  | Sq Ft |  |  |  | Large Job Gant Chart for KS.xlsx
 |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  | PACE JOBS FOR MS.xlsx | MS List for Nathan
 |  | On Hold/ Cancelled (Complete Row) |  |  |  |  |  |  |  |  |  |  |  |  | Timeline Requests.xlsx | Timeline Sheet
 |  | Print Complete (Column B ONLY) |  |  |  |  |  |  |  |  |  |  |  |  | https://www.weprint.com/number-out-calculator.asp | ←#Up Calculator
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Scheduling Kansas.xlsx | ←Old Timelines
Press | SchedTime | Due Date | Job# | Line# | Customer | Master [NAME] | QTY | H | W | Material | Sides | PrintMode | Kitting | #OfKits | Notes | DateRecieved | SqFt | LinearFT | Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Column10 | Column11
 |  | 2024-07-01 00:00:00
[NAME] | 12.75 | 2024-07-01 00:00:00 | 430 | 10.2 | HHGJ |  | 824 |  |  |  |  |  | Yes | 234 | PLACEMARKER- E03138666- JD BOC Owned Brands 0715.xlsx
[NAME] |  | 2024-07-01 00:00:00 | 248230 | 1 | SESY |  | 3372 | 42 | 89 | ART-  4960 - ABERDEEN 6653 FABRIC BANNER SOFT | 1 | [NAME] | Yes | 843
[NAME] |  | 2024-07-01 00:00:00 | 248250 | 2 | ACSP |  | 6 | 60 | 40 | CON-   4586 - FABRIC- LIGHTBOX- 126 | 1 | Backlit
[NAME] |  | 2024-07-01 00:00:00 | 248534 | 1 | SULO |  | 2 | 138 | 28 | CON-   4584 - FABRIC- FLAG- 126 | 1 | [NAME]
 |  | 2024-07-05 00:00:00
[NAME] | 55.6 | 2024-07-05 00:00:00 |  |  | HHGJ |  | 2028 |  |  |  |  |  | Yes | ? | PLACEMARKER
[NAME] |  | 2024-07-05 00:00:00 | 248643 | 1 | JAZZ |  | 1 | 324 | 27 | CON-   4584 - FABRIC- FLAG- 126 | 1 | [NAME]
 |  | 2024-07-08 00:00:00
[NAME] | 0.38 | 2024-07-08 00:00:00 |  |  | HHGJ |  | 114 |  |  |  |  |  | Yes | 231 | PLACEMARKER
[NAME] |  | 2024-07-08 00:00:00 | 248302 | 1 | ACSP |  | 5 | 60 | 40 | CON-   4586 - FABRIC- LIGHTBOX- 126 | 1 | Backlit
[NAME] |  | 2024-07-08 00:00:00 | 248459 | 1 | FIZZ |  | 2 | 118 | 88 | ART-  4960 - ABERDEEN 6653 FABRIC BANNER SOFT | 1 | [NAME]
[NAME] |  | 2024-07-08 00:00:00 | 248470 | 3-4 | SAVE |  | 7 | 200 | 60 | ART-  4589 - CELTIC BLACK BLACK | 1 | [NAME]
[NAME] |  | 2024-07-08 00:00:00 | 248392 | 1 | SAVE |  | 6 | 200 | 60 | ART-  4589 - CELTIC BLACK BLACK | 1 | [NAME]
[NAME] |  | 2024-07-08 00:00:00 | 248654 | 1 | SAVE |  | 1 | 240 | 72 | ART-  4589 - CELTIC BLACK BLACK | 1 | [NAME]
[NAME] |  | 2024-07-08 00:00:00 | 248648 | 1-2 | HALL |  | 6 | 36 | 84 | ART-  4960 - ABERDEEN 6653 FABRIC BANNER SOFT | 1 | [NAME]
[NAME] |  | 2024-07-08 00:00:00 | 248706 | 1 | [NAME] |  | 1 | 148 | 112 | ART-  4960 - ABERDEEN 6653 FABRIC BANNER SOFT | 1 | [NAME]
 |  | 2024-07-09 00:00:00
[NAME] |  | 2024-07-09 00:00:00 | 248538 | 1-2 | SAVE |  | 2 | 174 | 54 | ART-  4589 - CELTIC BLACK BLACK | 1 | [NAME]
[NAME] |  | 2024-07-09 00:00:00 | 248546 | 1 | GGOU |  | 10 | 32 | 22 | CON-   4584 - FABRIC- FLAG- 126 | 1 | [NAME]
[NAME] |  | 2024-07-09 00:00:00 | 248626 | 1 | WOMP |  | 24 | 36 | 24 | CON-   4584 - FABRIC- FLAG- 126 | 1 | [NAME]
 |  | 2024-07-10 00:00:00
[NAME] |  | 2024-07-10 00:00:00 | 248571 | 3-4 | SAVE |  | 7 | 200 | 60 | ART-  4589 - CELTIC BLACK BLACK | 1 | [NAME]
[NAME] |  | 2024-07-10 00:00:00 | 248580 | 1 | SAVE |  | 1 | 200 | 60 | ART-  4589 - CELTIC BLACK BLACK | 1 | [NAME]
[NAME] |  | 2024-07-10 00:00:00 | 248590 | 1-4 | MARC |  | 4 | 84 | 60 | ART-  4960 - ABERDEEN 6653 FABRIC BANNER SOFT | 1 | [NAME]
[NAME] |  | 2024-07-10 00:00:00 | 248591 | 1-8 | MARC |  | 8 | 136 | 72 | ART-  4960 - ABERDEEN 6653 FABRIC BANNER SOFT | 1 | [NAME]
[NAME] |  | 2024-07-10 00:00:00 | 248656 | 1 | SAVE |  | 1 | 174 | 88 | ART-  4589 - CELTIC BLACK BLACK | 1 | [NAME]
[NAME] |  | 2024-07-10 00:00:00 | 248661 | 1 | CRMX |  | 20 | 24 | 60 | ART-  4960 - ABERDEEN 6653 FABRIC BANNER SOFT | 1 | [NAME]
[NAME] |  | 2024-07-10 00:00:00 | 248662 | 1 | CRMX |  | 30 | 24 | 60 | ART-  4960 - ABERDEEN 6653 FABRIC BANNER SOFT | 1 | [NAME]
 |  | 2024-07-11 00:00:00
[NAME] |  | 2024-07-11 00:00:00 | 248636 | 1 | JAZZ |  | 3 | 60 | 48 | CON-   4584 - FABRIC- FLAG- 126 | 1 | [NAME]
[NAME] |  | 2024-07-11 00:00:00 | 248672 | 1 | BERE |  | 6 | 74 | 125 | CON-   4584 - FABRIC- FLAG- 126 | 1 | [NAME]
[NAME] | 1.9 | 2024-07-11 00:00:00 | 248713 | 1-5 | BLST |  | 11 | 96 | 60 | CON-   4586 - FABRIC- LIGHTBOX- 126 | 1 | Backlit
 |  | 2024-07-12 00:00:00
[NAME] |  | 2024-07-12 00:00:00 | 248660 | 1 | VERN |  | 1 | 60 | 36 | CON-   4584 - FABRIC- FLAG- 126 | 1 | [NAME]
[NAME] |  | 2024-07-12 00:00:00 | 248674 | 2 | ARIE |  | 2 | 38 | 100 | CON-   4584 - FABRIC- FLAG- 126 | 1 | [NAME]
[NAME] |  | 2024-07-12 00:00:00 | 248702 | 1 | SAVE |  | 1 | 200 | 60 | ART-  4589 - CELTIC BLACK BLACK | 1 | [NAME]
[NAME] |  | 2024-07-12 00:00:00 | 248670 | 1 | CLIP |  | 4 | 34 | 94 | ART-  4589 - CELTIC BLACK BLACK | 1 | [NAME]
[NAME] |  | 2024-07-12 00:00:00 | 248726 | 1 | GGOU |  | 1 | 32 | 22 | CON-   4584 - FABRIC- FLAG- 126 | 1 | [NAME]
 |  | 2024-07-15 00:00:00
[NAME] | 7.84 | 2024-07-15 00:00:00 | 248451 | 1 | NAC |  | 512 | 36 | 72 | ART-  4960 - ABERDEEN 6653 FABRIC BANNER SOFT | 1 | [NAME] | Yes | 488
 |  | 2024-07-22 00:00:00
[NAME] |  | 2024-07-22 00:00:00 | 248601 | 1 | ACSP |  | 6 | 60 | 40 | CON-   4586 - FABRIC- LIGHTBOX- 126 | 1 | Backlit
 |  | 2024-07-31 00:00:00
[NAME] |  | 2024-07-31 00:00:00 | 248301 | 1 | ACSP |  | 6 | 60 | 40 | CON-   4586 - FABRIC- LIGHTBOX- 126 | 1 | Backlit