Date Formula in a Gantt Chart Cell

Neal Kaye

I have tried to add formulas in the start date column for a gantt chart that reference a base start date cell and add a certain number of days to the start date. Is that possible?

 

Example of the formula I am implimenting:

= StarteDate + 10

 

The gantt chart start and end date columns use the Date/Time type of cell and Date type cell.

J. Craig Williams

Neal,

 

Are you trying to add a formula to the StartDate colum?

If that is the case, it isn't allowed. The columns associated with the Project Settings don't allow formulas.

 

Unfortunately.

 

Try using Predecessors and lead/lags instead.

http://help.smartsheet.com//customer/portal/articles/765727

 

 

Craig