Gantt Chart Dependency Settings - Choosing new date range display columns deletes the formulas in th

ozgur kaya

Hi;

When I choose columns (which includes formulas) for the "Start date column" and "End date column" in the "Edit Gantt Settings->Dependency Settings" dialog, formulas in the cells of newly selected columns ("Date range display" options) are being deleted automatically. Is there a way to prevent this?

Note: I need to swap two groups of Start Dates-End Dates for previewing the gantt chart status when a collaborator requests a new Start Date-End Date for the specific rows.

 

Thanks in advance.

Travis

Ozgur, certain columns cannot contain formulas if they are associated with dependencies. This includes the start/end date, duration, % complete, and predecessor columns. Because these columns cannot contain formulas, they are stripped out when you associate them with dependencies. As a workaround you could have a third set of start/end date columns where you copy and paste the data from your columns containing the formulas and use the third set of columns to view the data in your Gantt chart.