Automate Duration Column in Gantt Chart
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?
Tags:
Answers
-
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
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!