Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
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
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
