How do I create a formula to show how many weeks/days out a task needs to be completed?

Options

For example, if I have an event, or a project live date, and I want a task list that says

Task 1 is due 8 weeks prior

Task 2 is due 3 weeks prior

etc...I am new to this and cannot figure out the formula!

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!