Level 2 sprint 3 3.3.5 confirmed Po delivery formula


I have used formula  for confirmed PO delivery line item   IF PO submitted =1 Then OFFSET(PO Submitted ,shipping time weeks ,0)Else 0 but this formula is not giving desired result of offsetting PO submitted in confirmed PO delivery..attached the screen shot for the issue please help me out on this 



  • according to the logic, on your screenshot, for week 3, po submitted = 0, then what should be the value of confirm po delivery for that week?