How to auto calculate dates


This works if the contract term is 3 years then End Date but it won't work if the contract term is another number. How do I make it auto calculate if the contract term is 1, 2, 3 or 5 years?



Best Answer

  • Toufong Vang
    Toufong Vang ✭✭✭✭✭
    Answer ✓

    Hi, @WinaHath .

    Rename the column "Contract Term [Years]" to use parentheses, "Contract Term (Years)".

    In your original formula, replace "3" with [Contract Term (Years)]@row .

    Your updated formula will be =DATE(YEAR([Effective Date]@row) + [Contract Term (Years)]@row, MONTH([Effective Date]@row), DAY([Effective Date]@row)) .


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!