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.