Adding Days to a Date Based on a Condition
Hi
I've trawled the forum for previous questions but can't seem to see one similar to what I need. I have a date column that I want to auto calculate based on a condition within another column.
If [Corrective actions to be completed] = "Immediate" or "5 working days", take [Corrective action chaser 1] + 11 days, if [Corrective actions to be completed] = "10 working days", take [Corrective action chaser 1] + 7 days. If [Corrective actions to be completed] is blank, return blank in [Corrective actions chaser 2]
The formula I have used is shown in the screen shot above but, it just returns a blank rather than the chaser 1 date + 11 days date, which was the expected return.
@Paul Newcome I know you have been my formula guru just lately, I'm assuming there is something relatively simple I am missing?
TIA
Cheryl
Best Answer
-
I've now answered my own question and worked it out. The formula is:
=IF(OR([Corrective actions to be completed]@row = "Immediately", [Corrective actions to be completed]@row = "5 working days"), [Corrective action chaser 1]@row + 11, [Corrective action chaser 1]@row + 7)
Answers
-
Try to get rid of the parenthesis in front of the second IF statement -it is a pink parenthesis. Also remember to get rid of the closing parenthesis that is a result of it.
-
-
I've now answered my own question and worked it out. The formula is:
=IF(OR([Corrective actions to be completed]@row = "Immediately", [Corrective actions to be completed]@row = "5 working days"), [Corrective action chaser 1]@row + 11, [Corrective action chaser 1]@row + 7)
-
Glad you got it sorted! 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!