Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
duration adjusted for resource Allocation %
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?
Comments
-
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.
Categories
- All Categories
- 14 Welcome to the Community
- 10.7K Get Help
- 63 Global Discussions
- 69 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives