Spreadsheet: 684092d1593139243-i-need-to-auto-populate-a-range-of-cells-if-criteria-that-is-in-a-separate-cell-isnt-met-mld-staffing-1-1-2017-newtonus_prime-
Sheet: Sheet2

 | NEEDS | DAY SHIFT |  | EVENING SHIFT |  | MID SHIFT
 | 1 | GROUP LEADER |  | GROUP LEADER |  | GROUP LEADER
 |  | BARDIA RAJAEI |  | ADAM NEWTON |  | [NAME]
 | 1 | ASST. GROUP LEADER |  | ASST. GROUP LEADER |  | ASST. GROUP LEADER
 |  | [NAME]  SALADIN |  | [NAME] |  | MONIQUE WHITE BEAR CLAW
 | 4 | PROCESS TECHS |  | PROCESS TECHS |  | PROCESS TECHS
 |  | [NAME] |  | [NAME] |  | DAVE GOSAL
 |  | ALLEN SUTTON |  | AHMAD AUSTIN (TRAINING) |  | ORLANDO BARRON
 |  | MOLLY KAMARA |  | SCOTT BARNCORD |  | BRANDON PENDLTON
 |  | [NAME] (TRAINING) |  |  |  | [NAME] CLEMONS
 |  | [NAME] (TRAINING)
 | 1 | OFFICE FLOATER |  | OFFICE FLOATER |  | OFFICE FLOATER
 |  | GRISELDA RETANA |  | ALEX SOLIS |  | STACEY BALLARD
 | 3 | FLOATERS |  | FLOATERS |  | FLOATERS
 |  | BECKY  HOWELL |  | LINDSAY TRUONG |  | LIONELL BROWN
 |  | [NAME] |  | SYPHENG PHOMMATHIRATH |  | [NAME]
 |  | PHONSAMAY  SIVORAVONG |  | KHANKEO POWKOM |  | PAULA PACHOLKE
 | 5 | MATERIAL HANDLERS |  | MATERIAL HANDLERS |  | MATERIAL HANDLERS
 |  | 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 |  | CLEANER |  | CLEANER
 |  | MARIA  LEMOINE |  | [NAME] |  | [NAME]
 | 12 | OPERATORS |  | OPERATORS |  | OPERATORS
 |  | [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 |  | IML Tech |  | IML Tech
 |  | 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
 |  | TEMP OPERATORS |  | TEMP OPERATORS |  | TEMP OPERATORS
 |  | PART TIME |  | PART TIME |  | PART TIME
 |  | FERI CHANDRA (M,T,W) |  | CALEB GROTHER
 |  | JUSTIN FREELAND (M,T,TH,F)
 |  | OPS+IML [NAME] |  | OPS+IML [NAME] |  | OPS+IML [NAME]
 |  | TEMP STAFFING |  | TEMP STAFFING |  | TEMP STAFFING
 |  | TOTAL STAFFING |  | TOTAL STAFFING |  | TOTAL STAFFING
 |  | Total openings on Days |  | Total openings on Eves |  | Total openings on Mids