Date formulas

Aaron Olsen
Aaron Olsen ✭✭
edited 10/12/20 in Formulas and Functions

I am very new to this and don't work with formulas often. I am trying to create a formula that will update the finish date automatically based on a given timeframe. For example start date is 10/12 next column gives time expected to complete task 6 weeks. I want to create a formula that will autofill the completion date in the next column. This in turn will autofill in the gantt chart calendar based on the template i'm using.



Best Answer


  • Thank you this is super helpful!

  • Ramzi K
    Ramzi K ✭✭✭✭✭

    @Aaron Olsen

    Happy to help.



    Ramzi Khuri - Principal Consultant @ Cedar Tree Consulting (

    Feel free to email me:

    💡 If this post helped you out, please help the Community by marking it as the accepted answer/helpful.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!