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

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
    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. 


    Kaveri Vipat

    Senior Associate - Smartsheet Development, Ignatiuz Software

    2023 Core Product Certified

    Did this answer help you? Show some love by marking this answer as "Insightful💡" or "Awesome❤️" and "Vote Up⬆️"

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!