Hi Experts
I hope you are doing wonders in your life.
I am struck with the formula. I want to link the SKU code tab estimated arrival date with the Restock date. The arrival date for an SKU is different in a different row. I want to make a formula that links the SKU arrival date with the Restock date. For example, SKU 101-1015-V2 Date of OOS (Out of Stock) is 27 Dec 23. The minimum date is 1 Nov 21 and the maximum date is 14 Aug 23. As the SKU has not been ordered yet so the formula should reflect "Not ordered Yet". In a similar case if Data is available like 5 Jan 23 then it places the 5 Jan 23 in front of SKU in the Restock column.
Constraint any value less than the OOS (Out of Stock) should not be placed in Restock Date columns. For example, OOS Date < Restock Date
I hope you are doing wonders in your life.
I am struck with the formula. I want to link the SKU code tab estimated arrival date with the Restock date. The arrival date for an SKU is different in a different row. I want to make a formula that links the SKU arrival date with the Restock date. For example, SKU 101-1015-V2 Date of OOS (Out of Stock) is 27 Dec 23. The minimum date is 1 Nov 21 and the maximum date is 14 Aug 23. As the SKU has not been ordered yet so the formula should reflect "Not ordered Yet". In a similar case if Data is available like 5 Jan 23 then it places the 5 Jan 23 in front of SKU in the Restock column.
Constraint any value less than the OOS (Out of Stock) should not be placed in Restock Date columns. For example, OOS Date < Restock Date