Here's what I want to be able to do for resource management. Is there a workaround to accomplish this?
- Assign individual resources (they are not licensed users) to a team\group. Assigning tasks to multiple individuals does not work for me.
- Each individual has default work hours. E.g. 8 hrs. It can be modified if needed
- Individual availability hours roll-up to available hours at the team level.
- The groups need to be available to at the workspace level. So, it can be used in all the sheets in the workspace. The groups should be available to users with edit permissions in the workspace.
- At a sheet level, we should be able to assign tasks to a group.
- At a sheet level, we should be able to assign a % of the team's available hours to the task. The default could be 100%.
- If the team's available numbers of hours is less than the task duration, the task is flagged for resource contention.