Help with Auto-populating dates

Kelly Leevey
Kelly Leevey ✭✭
edited 12/09/19 in Formulas and Functions

Hi All, 

I have been trying to figure out how to auto-populate dates.  I've figured out that if I enter a date, type in the desired duration of when I'd like the task due, it populates the due date for me.  All of that seems like it's project in the future and I'm running into this particular problem.

Let's say I need to complete a training for people on 09/22/2019.  I have a task that needs to be completed 2 weeks BEFORE 09/22/2019.  How do I get those dates to auto-populate?  So far, it just projects out 2 weeks after the training.  I am a baby level using formulas (only really know the sum function)...can anyone help me figure this scenario out?




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!