Is there a way to have data from one sheet auto update the start & finish date within a schedule?
I have built a schedule with proposed start/ finish dates (which are driving the Gantt) as well as a column for the actual start/ finish dates. I can link the actual columns to the data sheet where teammates are inputting their actuals, but those columns do not drive the Gantt chart to show if any lag has occurred. I am trying to keep the schedule to a limited group for access that s why I am not having teammates update directly in the schedule sheet, but also have real time updates without having to manually change dates in the schedule myself. Any suggestions?