Converting Numeric Values to Days

Dennis Sullivan

Hi, I would like to input a quantity in a cell and use a formula to convert it into days of production.  I have accomplished this with the exception of the Duration column does not convert the numerical value into days for the Gantt chart.  Please help.

Thank you, 

Dennis

Schiff A.

Hi Dennis,

At this time, the Duration column in a sheet cannot accept formulas when dependencies are enabled.

You can submit an enhancement request by clicking on the 

Submit Product Enhancement Request link on the right hand side of community pages (under "quick links). This will let our product team know about what kinds of features and functionality customers are looking for.

https://help.smartsheet.com/articles/765737-project-sheet-columns-start-date-end-date-duration-complete-and-predecessors

Thanks!

Schiff