Converting Numeric Values to Days

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

formula 2.JPG

Find more posts tagged with

Construction

Formulas

Gantt View

Comments

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