Date formulas


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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!