Automate Duration Column in Gantt Chart

ljordan

I'm trying to Great a semi automated Gantt which sets an automatic duration of a task based on Hours, Variance and allotted staff. When task dependencies are on i appear to not be able to write a Formula into this cell. is there a way around this aside from manually doing the maths on the hours every time?

Alejandra

Hi @ljordan,

Formulas are not currently supported in project columns (like the duration column) when dependencies are enabled, but this would be a great opportunity to submit a Product Enhancement Request .

If needed, more information on project columns can be found here: https://help.smartsheet.com/articles/765737-project-sheet-columns-start-date-end-date-duration-complete-and-predecessors