Trying to back into a date and also use duration
I have a construction timeline that has tasks that lead up to it. The top Due Date is when the project needs to be completed by. The Days From Open need to tell me when to stat the task. (ex. first task start 90 days from 1/3/20). I also want to add a duration of how long that "90 day" task should take to complete. Basic question but how do I do this? When I add the duration with dependencies, it removes all of my dates. Is there a better template I should be working from?
Help Article Resources
Check out the Formula Handbook template!