Adding Days to a Date Based on a Condition


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?




Best Answer

  • Cheryl Collins
    Cheryl Collins ✭✭✭✭✭✭
    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)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!