Task duration as a function of the number of resources

Michael Wilson

Hello!

Can task duration be calculated as a function of the number of resources?

If one person takes three weeks then allocating three people should complete the task in one week, etc.

This should be easy but I can't find this capability.

I'd appreciate suggestions on how to do this.

Thank you,

Michael

Find more posts tagged with

Project Management

Accepted answers

All comments

David Joyeuse

Hi @Michael Wilson

Sounds doable, but would require a small database with duration of every and one task for 1 person.

Then your task duration column would have a formula like this one:

=IFERROR((INDEX({Task Duration Sheet - Duration Range}, MATCH([Task Name Column]@row, {Task Duration Sheet - Task Name Range},0)) / COUNTM([Affected to]@row),"")

The IFERROR being here to prevent divide by zero errors when the [Affected to] is blank.

Michael Wilson

Hi @David Joyeuse

Thank you for your suggestion.

I was hoping for a simpler "Resource multiplier" column. Then you could charge the resourcing for 0 to 100 % for one person AND also add multiple resources.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.