Assign To a list of people - one per entry


I'm trying to assign a new incoming task to 1 person, from a list, in order of the list. How can I do that?

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    Ok. You will need to insert a column on the List of Resources and use a formula that counts how many times they have been used.

    =COUNTIFS({Task Sheet Resource Column}, @cell = Resource@row)

    Then on the task list column, you would use something like this to pull the next in line from top to bottom:

    =INDEX({Resource List Resource Column}, MATCH(MIN({Resource List Count Column}), {Resource List Count Column}, 0))