Project completion T-minus date


Hello - Thank you in advance

Requesting a column formula in my project sheet.

I have a "Project completion" date as well as tasks that work back by week (can be days if easier). I would like to be able to enter any "Project completion" date and ensure the tasks change based on that date.

IE: Project completion is August 12th and Task A has to be completed 4 weeks earlier I would like the task to show a start date of September 12th (or 30 days earlier)

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!