Formulas with Conditions

Yessica
Yessica
edited 12/09/19 in Smartsheet Basics

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. 

Comments