Why is PROJECTED COMPLETION DATE Column Autopopulating with Date After Date Assigned

Ann.Cracovaner

One of my PMs has noticed that the date in the PROJECTED COMPLETION DATE column on an assignment tracker is autopopulating with a date one day after the DATE ASSIGNED date. We have dependencies turned on to utilize Resource Management functionality with the sheet, but aren't using the PREDECESSORS column to capture any information. Is there a way to remove this date autopopulation without disabling the dependencies?

Joe Goetschel

Hi @Ann.Cracovaner Throw 30 mins on my calendar and I can walk you through some ideas!

https://scheduler.zoom.us/joe-goetschel

Joe Goetschel

Hi Ann! Can you share some screenshots of your sheet?

Ann.Cracovaner

Here's what's happening @Joe Goetschel . See how the Projected Completion Date (by Resource) field is no longer an editable field? This happened just after I saved the card.

Joe Goetschel

Hi Ann! Yep, you are correct this is due to dependencies. These project management settings are needed for Resource Management.

You have the start date and duration and this is what drives your end date because you have to track the allocation to a timeline.

Ann.Cracovaner

Thanks for confirming @Joe Goetschel ! Do you know of a way to work around this or adjust the settings so the date doesn't autofill? Or fills with something else?

Joe Goetschel

Hi @Ann.Cracovaner Throw 30 mins on my calendar and I can walk you through some ideas!

https://scheduler.zoom.us/joe-goetschel

Ann.Cracovaner

Thanks @Joe Goetschel ! Just blocked off some time for us to meet!