Task duration as a function of the number of resources


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,



  • David Joyeuse
    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.

  • 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.