Formula under Duration in a Gant chart


Hi there, I'm new to smartsheet I want to switch from MS Project to smartsheet to set up the planning schedule. I know we can assign multiple of people to a task but at the planning/biding level, I just want to juggle with the number of resources to set the best outline.

I would like to set the work (total effort to accomplish a task), then the number of people and then have the duration calculated like(Work / #people). As soon as I set the calculated column as the duration I lose the formula. See My screenshot below.

Thanks for your help. 



  • Shaine Greenwood

    Hi Bernard—

    Formulas currently can't be added to the duration column or any column being used for dependencies as there are hidden dependencies-specific formulas performing calculations on the backend.

    One way that you can work around this is to create a new text/number column and add your effort calculations there. You can then type the result in to your real duration column.

    When you have a moment, submit your feedback to allow functions in dependencies columns through the Product Enhancement Request form (under Quick links to the right of the community site).

  • Caitlin Smith

    I have the same problem. I have a repeatable project that have three possible duration (0 -not required, high Complexity, Low complexity). I was just going to use a formula to look up variables I have in the project summary to determine which applies and get it up from a hidden column. It seems you cannot do any formulas in Duration or % Complete

  • Tom L

    I have the same issue and this would be a nice feature to have.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!