Formulas with Conditions
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
-
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.
-
Thank you for your response.
Am I replacing the current formula with the one that you are recommending? Or should I combine them?
-
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.)
-
It does work, but it is not adding 14 days if it is not a "T" type "Q".
Types:
QA
X
C
V
Q
-
Following up.
-
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?
-
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?
-
I am adding a screen shot of the column and types. The letter system is how we code our projects.
-
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).
-
Thank you, Robert and Shaine! We got it to work!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 302 Events
- 33 Webinars
- 7.3K Forum Archives