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.

Thanks,

Aaron

Best Answer

Answers

  • Thank you this is super helpful!

  • Ramzi K
    Ramzi K ✭✭✭✭✭

    @Aaron Olsen

    Happy to help.

    Cheers,

    Ramzi

    Ramzi Khuri - Principal Consultant @ Cedar Tree Consulting (www.cedartreeconsulting.com)

    Feel free to email me: ramzi@cedartreeconsulting.com

    💡 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!