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.
Comments
-
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).
-
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
-
I have the same issue and this would be a nice feature to have.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.1K Get Help
- 414 Global Discussions
- 221 Industry Talk
- 460 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 141 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!