Add Dates Based on Conditions

Benny Velazquez

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!

Nic Larsen

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.

Nic Larsen

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.

Benny Velazquez

@Nic Larsen -That did it, I was trying the same but was adding the wrong symbol after dates. thank you so much for the help and quick response.😊