Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

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

ozgur kaya
edited 12/09/19 in Archived 2015 Posts


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
    Travis Employee
    edited 07/06/15

    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. 

This discussion has been closed.