# Formulas with Conditions

Options
edited 12/09/19

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.

• Employee
Options

Hi Yessica,

Try something like this:

=IF(Type289 = "Q", \$[Order Date]289 + 7)

Make sure that you're referencing the correct cell (correct column name and row number) when you use the above formula in your own sheet.

If that doesn't work, let me know what error you receive and I can help further.

• Options

Am I replacing the current formula with the one that you are recommending? Or should I combine them?

• Employee
Options

Test it out in one cell to make sure it works as expected, but ultimately you'd replace your formula with the one I provided. (Don't combine them.)

• edited 01/12/18
Options

It does work, but it is not adding 14 days if it is not a "T" type "Q".

Types:

QA

X

C

V

Q

• Options

Following up.

• Employee
Options

Hi Yessica,

I'm not sure what you mean by a "T" type "Q."

"T" doesn't seem to be a type.

Do you have a different column with other type labels?

• Employee
Options

Hi Yessica,

I'm not sure what you mean by a "T" type "Q."

"T" doesn't seem to be a type.

Do you have a different column with other type labels?

• Options

I am adding a screen shot of the column and types. The letter system is how we code our projects.

• Employee
Options

Hello Yessica,

If I understand what you're looking for correctly, then you do want to combine Shaine's formula and your original formula. This will set the Due Date to 1 week after the Order Date if the Type column is set to "Q", and 2 weeks after the Order Date otherwise.

=IF(Type289 = "Q", \$[Order Date]289 + 7, \$[Order Date]289 + 14)

This is done by adding your original formula to the [value_if_false] section of the IF formula. More of how an IF function is structured can be found here (https://help.smartsheet.com/function/if).

• Options

Thank you, Robert and Shaine! We got it to work!