Resource profiling
I have a requirement where each task requires a % allocation profile instead of the standard flat % allocation throughout the duration of the task - is it possible to set this up?
For example, a task is 9 months long:
Month 1 requires 50%
Month 2 - 6 requires 100%
Month 7-8 requires 50%
Month 9 requires 25%.
Comments
-
Hello Lee,
If you're using the resource management functionality, there currently isn't a way to automatically provide a % allocation profile based on duration. (More info on Resource Management is available in the help center.)
If you're not using the resource management functionality then you can place an IF statement in your % allocation column that automates this. Example:
=IF(NETWORKDAYS([Start Date]1, [End Date]1) = 270, 0.25, IF(OR(NETWORKDAYS([Start Date]1, [End Date]1) = 30, AND(NETWORKDAYS([Start Date]1, [End Date]1) <= 210, NETWORKDAYS([Start Date]1, [End Date]1) >= 240)), 0.5, IF(AND(NETWORKDAYS([Start Date]1, [End Date]1) <= 60), NETWORKDAYS([Start Date]1, [End Date]1) >= 180), 1)
More about Smartsheet functions can be found in the help center: https://help.smartsheet.com/functions
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives