Help with Auto-populating dates
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
Check out the Formula Handbook template!