Change the date to a new date in the future when met the criteria

EmilyEchevarria

Hi, I curretnly have a smarthsheet that consistit of giving reminders and follow-ups for some actions. I am looking for a formula that basically (IF the due date column is less and the done column is checked, then change the due date for 2 months after.

Thank You

Kaveri Vipat

Hi EmilyEchevarria 

I hope you are doing well, 

According to your condition, you can use a helper column “due date of next 2 months" for the formula because we can’t put the formula in the due date column if you will put the formula in the due date column then you can’t fill the due date so that’s why I'm using another column for the due date of next 2-month. 

Try this formula on the due date of the next 2 months: 

=IF(AND([due date]@row < TODAY(), done@row = 1), DATE(YEAR([due date]@row), MONTH([due date]@row) + 2, DAY([due date]@row))) 

I hope this is useful to you, Have a Good Day.