Spreadsheet: 857170d1706208154-help-with-vstack-formula-kansas-scheduler-newtonus_prime-
Sheet: Kitting Schedule

[NAME] from date below↓
2024-01-24 00:00:00
Column F (Digital & Fabric) | Column D | Column N | Column G | Column C | O
Client | Job # | # of Stores | # of Pieces | Ship Date | Notes |  |  | Master [NAME] | Job# | #OfKits | QTY | Due Date
=VSTACK(FILTER({Digital!F:F,Digital!D:D,Digital!N:N,Digital!G:G,[NAME]:C,Digital!O:O}, ([NAME]:C>=A2)*(Digital!M:M="Yes")), FILTER({Fabric!F:F,Fabric!D:D,Fabric!N:N,Fabric!G:G,Fabric!C:C,Fabric!O:O}, (Fabric!C:C>=A2)*(Fabric!M:M="Yes"))) |  |  |  |  |  |  |  | CABR 244207 [24] | 244207 | 82 | 328 | 2024-01-23 00:00:00
 |  |  |  |  |  |  |  | GGPM Monthly |  |  |  | 2024-01-23 00:00:00
 |  |  |  |  |  |  |  | BASS 243891 [24] | 243891 | 128 | 128 | 2024-01-24 00:00:00
 |  |  |  |  |  |  |  | SULO 244884 [24] | 244884 | 34 | 34 | 2024-01-24 00:00:00
 |  |  |  |  |  |  |  | BASS | 244068 | 126 | 384 | 2024-01-26 00:00:00
 |  |  |  |  |  |  |  | TMOB | 244313 | 300 | 300 | 2024-01-26 00:00:00
 |  |  |  |  |  |  |  | BASS 244166 [29] | 244166 | 2 | 129 | 2024-01-29 00:00:00
 |  |  |  |  |  |  |  | CCOTO | 243556 | 100 | 200 | 2024-01-29 00:00:00
 |  |  |  |  |  |  |  | BASS 244170 [29] | 244170 | 2 | 256 | 2024-01-29 00:00:00
 |  |  |  |  |  |  |  | BASS 244072 | 244072 | 109 | 109 | 2024-01-29 00:00:00
 |  |  |  |  |  |  |  | First Systems and Resources 244184 [30] | 244184 | 75 | 75 | 2024-01-30 00:00:00
 |  |  |  |  |  |  |  | PROS 244341 [30] | 244341 |  | 8 | 2024-01-30 00:00:00
 |  |  |  |  |  |  |  | CKCC |  | 325 |  | 2024-01-30 00:00:00
 |  |  |  |  |  |  |  | P&S 244218 [31] | 244218 | 1 | 700 | 2024-01-31 00:00:00
 |  |  |  |  |  |  |  | SULO 244229-1 [31] | 244229 | 25 | 1 | 2024-01-31 00:00:00
 |  |  |  |  |  |  |  | GGPM | 21262 | 141 | 6021 | 2024-02-01 00:00:00
 |  |  |  |  |  |  |  | CALE 243915-1 [2] | 243915 | 3 | 9 | 2024-02-02 00:00:00
 |  |  |  |  |  |  |  | HHGJD | 243770 | 1 | 826 | 2024-02-02 00:00:00
 |  |  |  |  |  |  |  | CALE 243529-1 [5] | 243529 | 2 | 6 | 2024-02-05 00:00:00
 |  |  |  |  |  |  |  | Caleres 243530-1 [5] | 243530 | 6 | 18 | 2024-02-05 00:00:00
 |  |  |  |  |  |  |  | Caleres 243532-1 [5] | 243532 | 4 | 12 | 2024-02-05 00:00:00
 |  |  |  |  |  |  |  | [NAME] Jewelry |  | 145 | 995 | 2024-02-05 00:00:00
 |  |  |  |  |  |  |  | HHG JD 244006-7 [5] | 244006 | 1 | 36 | 2024-02-05 00:00:00
 |  |  |  |  |  |  |  | CALE 243526-1 [5] | 243526 | 13 | 26 | 2024-02-05 00:00:00
 |  |  |  |  |  |  |  | CALE 243537-1 [9] | 243537 | 1 | 3 | 2024-02-09 00:00:00
 |  |  |  |  |  |  |  | [NAME] 50% OFF |  | 145 | 995 | 2024-02-12 00:00:00
 |  |  |  |  |  |  |  | HHGJ HERO |  |  | 809
 |  |  |  |  |  |  |  | WEST 244038 [14] | 244038 | 20 | 97 | 2024-02-14 00:00:00
 |  |  |  |  |  |  |  | Essentials 55 Creative |  | 2 | 30 | 2024-02-14 00:00:00
 |  |  |  |  |  |  |  | BLAST MEDIA |  | 80 | 175 | 2024-02-16 00:00:00
 |  |  |  |  |  |  |  | E03058759 |  | 44 | 48 | 2024-02-28 00:00:00
 |  |  |  |  |  |  |  | [NAME] |  | 145 | 995 | 2024-03-15 00:00:00
 |  |  |  |  |  |  |  | TMOB- APPLE NPI- SPRING |  |  |  | 2024-03-15 00:00:00
 |  |  |  |  |  |  |  | [NAME] paper store |  |  | 1100 | 2024-03-25 00:00:00
 |  |  |  |  |  |  |  | TMOB- APPLE NPI- FALL |  |  |  | 2024-09-14 00:00:00
 |  |  |  |  |  |  |  | HHG [NAME] HHGJ 59 |  | 1 |  | 2024-01-24 00:00:00
 |  |  |  |  |  |  |  | CALE 244162 [26] | 244162 | 2 | 22 | 2024-01-26 00:00:00
 |  |  |  |  |  |  |  | HHG [NAME] |  | 217 | 466 | 2024-01-29 00:00:00
 |  |  |  |  |  |  |  | HHGJ Converse |  | 70 | 70 | 2024-01-30 00:00:00
 |  |  |  |  |  |  |  | HHGJ E03031696 | 72 | 95 | 279 | 2024-02-01 00:00:00
 |  |  |  |  |  |  |  | HHG [NAME] |  | 145 | 429 | 2024-02-02 00:00:00
 |  |  |  |  |  |  |  | HHG [NAME] Go | 243580 |  | 11335 | 2024-02-02 00:00:00
 |  |  |  |  |  |  |  | HHG JD Nike Need it Now FEB |  | 95 | 300 | 2024-02-02 00:00:00
 |  |  |  |  |  |  |  | ADIDAS HERO Corp OFC |  | 2 | 3 | 2024-02-06 00:00:00
 |  |  |  |  |  |  |  | [NAME] | 3190 | 263 | 526 | 2024-02-07 00:00:00
 |  |  |  |  |  |  |  | DXL |  | 210 | 242 | 2024-02-07 00:00:00
 |  |  |  |  |  |  |  | Las Vegas HERO |  | 2 | 9 | 2024-02-08 00:00:00
 |  |  |  |  |  |  |  | HHG [NAME] HERO |  |  | 809 | 2024-02-10 00:00:00
 |  |  |  |  |  |  |  | North American Corporation |  |  | 422 | 2024-02-13 00:00:00
 |  |  |  |  |  |  |  | Essentials 55 |  | 2 | 30 | 2024-02-14 00:00:00
 |  |  |  |  |  |  |  | Blast Media |  | 1 | 144 | 2024-02-16 00:00:00
 |  |  |  |  |  |  |  | Nike Need it Now |  | 166 | 527 | 2024-02-26 00:00:00
 |  |  |  |  |  |  |  | E03058759 HHGJ Womens Vans |  | 44 | 48 | 2024-02-28 00:00:00
 |  |  |  |  |  |  |  | DXL |  | 215 | 242 | 2024-03-04 00:00:00
 |  |  |  |  |  |  |  | Hallmark- [NAME] |  |  |  | 2024-03-27 00:00:00