Hello,
My goal is to have a formula populate the dues dates with one condition.
Currently Drawing Due Date is populated 2 weeks from Order Date
If the "Type" Column is "Q" then I need the Drawing Due Date to be 1 week from Order Date.
Current Formula: =$[Order Date]289 + 14
Thank you for helping me with this in advance.