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?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!