Formulas with Conditions

Yessica

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. 

Shaine Greenwood

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.

Yessica

Thank you for your response.

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

Shaine Greenwood

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.)

Yessica

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

 

Types: 

QA

X

C

V

Q

Yessica

Following up. 

Shaine Greenwood

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?

Shaine Greenwood

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?

Yessica

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

Robert S.

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).

Yessica

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