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


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!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!