Add Dates Based on Conditions

Options

Hi,

I'd figure out on how to add date based on condition, but now I would like to add date based on the condition I chose. For example, if I chose "Low" than 30-Days from Date Entered, but if I chose "Moderate" than 60-Days from Date Entered. I think this is a If(Or but I am not sure. See below sample.

Hopefully this make sense.

Thanks!

Best Answer

  • Nic Larsen
    Nic Larsen ✭✭✭✭✭✭
    edited 06/03/24 Answer ✓
    Options

    Just a nested if statement needed:

    IF([Inspection Severity]@row = "Low", [Date Entered]@row + 30, IF([Inspection Severity]@row = "Moderate", [Date Entered]@row + 60

    and so on until you have all your conditions.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!