The below formula appears to take care of the issue: IF OFFSET(PO Submitted, -Shipping Time Weeks, 0) > 0 THEN OFFSET(PO Submitted, -Shipping Time Weeks, 0) ELSE 0 Reason: Previous formula: IF PO Submitted > 0 THEN POST(PO Submitted, Shipping Time Weeks) ELSE 0 Issue in the previous formula: For the IF formula to run the calculation mentioned in the IF TRUE part, it was checking the current month's PO submitted value. Whereas we want it to check the value mentioned in the PO Submitted column mentioned 2 weeks ago.
... 查看更多