Set an End Date for Project and use predeceasors to work backwards

HGenik

I have Parent and Child rows set up in my sheet - Parent is the project and Child rows are the steps. I want to set the expected "Completion date" in the final child row and automatically (with set durations) work backwards to determine the expected "Start and Completion date" for the child rows that need to happen prior.

I am able to do this from a start date of the first child row but cannot figure out to go backwards from the completion date.

Lindsay AR

@HGenik In your predecessor column you can do a FS and work backwards rather than forwards. So, if row 17 is where you want to enter your date and want the rest to fill in then the predecessor in row 16 would be 17FS. You can add in - or +(number) after 17FS if you need to adjust lag time. If no lag, it would look something like this:

Row Predecessor

14 15FS

15 16FS

16 17FS

17