Hi!

I am struggling to complete the INV01 Module Line Item Formula Details. It seems like everything is working except for the "Confirmed PO Delivery" formula. Below is the formula I have and the result I get:

IF PO Submitted = 1 THEN OFFSET(PO Submitted, -Shipping Time Weeks, -1) ELSE 0

I've found similar questions in the community but no clear way to resolve this.

Also, instead of the "-1" in the offset formula I would normally include "0" but this isn't the issue.

Can someone help me resolve this? The goal is to have the 1 from "PO Submitted" be reflected in week 3 of "Confirmed PO Delivery"

Thanks in advance!