duration adjusted for resource Allocation %

fractal76

We would like to be able to keep track of absolute effort (in days), but the Duration column that effects End Date, should be adjusted for Allocation %. So if a resource is allocated 10% on a task estimated at 1 day, it would actually take 10 days (duration) of wall clock time.

 

May be a formula where Duration = Effort *100/Allocation%

Where Effort is a number column with the absolute effort estimate?

JohnHinkle

Here is a similar question from a couple weeks ago: https://community.smartsheet.com/discussion/allocated-time-versus-duration

 

You could build a formula like that one you suggested but you cannot add formulas to the duration column if dependencies are enabled. You could add an additional duration column with this formula then copy and paste the result over to the actual duration column.