Spreadsheet: 683915d1593043903-i-need-to-auto-populate-a-range-of-cells-if-criteria-that-is-in-a-separate-cell-isnt-met-mld-staffing-1-1-2017
Sheet: Sheet1

 | NEEDS | DAY SHIFT |  | EVENING SHIFT |  | MID SHIFT
 | 1 | GROUP LEADER | 1 | GROUP LEADER | 1 | GROUP LEADER | 1
 |  | BARDIA RAJAEI |  | ADAM NEWTON |  | [NAME]
 | 1 | ASST. GROUP LEADER | 1 | ASST. GROUP LEADER | 1 | ASST. GROUP LEADER | 1
 |  | [NAME]  SALADIN |  | [NAME] |  | MONIQUE WHITE BEAR CLAW
 | 4 | PROCESS TECHS | 5 | PROCESS TECHS | 3 | PROCESS TECHS | 4
 |  | [NAME] |  | [NAME] |  | DAVE GOSAL
 |  | ALLEN SUTTON |  | AHMAD AUSTIN (TRAINING) |  | ORLANDO BARRON
 |  | MOLLY KAMARA |  | SCOTT BARNCORD |  | BRANDON PENDLTON
 |  | [NAME] (TRAINING) |  | OPEN |  | [NAME] CLEMONS
 |  | [NAME] (TRAINING)
 | 1 | OFFICE FLOATER | 1 | OFFICE FLOATER | 1 | OFFICE FLOATER | 1
 |  | GRISELDA RETANA |  | ALEX SOLIS |  | STACEY BALLARD
 | 3 | FLOATERS | 3 | FLOATERS | 3 | FLOATERS | 3
 |  | BECKY  HOWELL |  | LINDSAY TRUONG |  | LIONELL BROWN
 |  | [NAME] |  | SYPHENG PHOMMATHIRATH |  | [NAME]
 |  | PHONSAMAY  SIVORAVONG |  | KHANKEO POWKOM |  | PAULA PACHOLKE
 | 5 | MATERIAL HANDLERS | 5 | MATERIAL HANDLERS | 5 | MATERIAL HANDLERS | 5
 |  | HUGO MARTINEZ |  | TYLER GRINDOL |  | [NAME]
 |  | [NAME] |  | [NAME] WOLFE |  | [NAME]
 |  | [NAME] |  | ODALIS PARGA |  | SCOTT WALTER
 |  | [NAME] |  | CRYSTAL FREDERICKS |  | RAY FINCH
 |  | GRANT KIMBLE |  | EARON COOPER |  | DONTE WICHMAN
 | 1 | CLEANER | 1 | CLEANER | 1 | CLEANER | 1
 |  | MARIA  LEMOINE |  | [NAME] |  | [NAME]
 | 12 | OPERATORS | 11 | OPERATORS | 11 | OPERATORS | 9
 |  | [NAME] |  | SILVIA LIRA |  | [NAME] TODD
 |  | MARGARET HERZOG |  | [NAME] TURNER * |  | NASIRU YUNUSAH
 |  | LENY NAVA |  | [NAME] |  | PUNNIDA CRAWFORD
 |  | BOONYANG SAYVONGSA |  | [NAME] |  | PETE THAMMAVONGSA
 |  | YEN CHAU |  | LAKPA SHERPA |  | KHAMPHET SENGSATHEVANE
 |  | OFELIA CERVANTES |  | ANGRINJI SHERPA |  | FELICIA GREEN
 |  | FIDENCIO  CERVANTES |  | QUAN LE |  | [NAME] MEREDITH
 |  | [NAME] |  | YEN TRAN |  | [NAME]
 |  | JEMMY LESMANA |  | [NAME] |  | MARISOL RIVERA
 |  | QUOC CHIEU |  | JARED NOVICK |  | PENDING
 |  | HALIMATA YUNUSAH |  | [NAME] |  | PENDING
 |  | PENDING |  | PENDING |  | PENDING
 |  | PENDING |  | PENDING |  | OPEN
 |  |  |  |  |  | OPEN
 | 18 | IML Tech | 14 | IML Tech | 13 | IML Tech | 12
 |  | NGA DANG |  | NOAH JOHNSON |  | ANAN ARDONG
 |  | SARAH IDEKER |  | SONNY KHANTHAVIXAY |  | [NAME]
 |  | JUAN  SOTO |  | TANIT ARDONG |  | MONTIEN BOUTVONG
 |  | ELVIA DE HARO |  | [NAME] |  | KHAMPHAN SENGDARA
 |  | KAVONE INTHAMATH |  | REBECCA SHIELDS |  | VILAISENG SENGDARA
 |  | RAMONA  JIMENEZ |  | [NAME] |  | ERNEST GORDON
 |  | STEFANIE VINSONHALER |  | BOUNNAM OUTHONESKA |  | [NAME]
 |  | [NAME] |  | AHMED SOFOWOKE |  | [NAME]
 |  | NATASHA  FRAKES |  | JUSTIN GULANE |  | SUNIE THOMPSON
 |  | ARISBETH DE LEON |  | MODINAT ATOROMOLA |  | KEATON NANCE
 |  | [NAME] |  | BAMBI ARYES |  | TRENT DRODGE (LW)
 |  | [NAME] |  | PAIGE JONAS |  | [NAME] (THERMO)
 |  | THUY CHIEU |  | TYEISHA BELL |  | OPEN
 |  | ROSA MANDUJANO |  |  |  | OPEN
 |  | PENDING
 |  | OPEN |  |  |  |  |  |  |  |  |  |  | OPEN
 |  | TEMP OPERATORS | 0 | TEMP OPERATORS | 0 | TEMP OPERATORS | 0
 |  |  |  |  |  |  |  |  | Roll
 |  |  |  |  |  |  |  |  | Undecided
 |  | PART TIME | 2 | PART TIME | 1 | PART TIME | 0
 |  | FERI CHANDRA (M,T,W) |  | CALEB GROTHER
 |  | JUSTIN FREELAND (M,T,TH,F)
 |  | OPS+IML [NAME] | 25 | OPS+IML [NAME] | 24 | OPS+IML [NAME] | 21
 |  | TEMP STAFFING | 0 | TEMP STAFFING | 0 | TEMP STAFFING | 0
 |  | TOTAL STAFFING | 44 | TOTAL STAFFING | 40 | TOTAL STAFFING | 37 |  | Molding Total | 121
 |  | Total openings on Days | 1 | Total openings on Eves | 1 | Total openings on Mids | 4