Auto-Assign Resouces using "One or the other" type formula? RRS feed

  • Question

  • Hi,

    I have a number of jobs that could easily be carried out by either of our two machines. Is it possible when assigning resources to a task to get project to auto-assign EITHER "Resource1" OR "Resourse2" depending on availability?

    Many Thanks,



    Tuesday, January 10, 2012 4:24 PM


  • b_frazer,

    Although this may sound like a fairly simple request, as far as I know there is no way to automate this without using VBA. It wouldn't be that difficult, but nonetheless a macro is required.

    As a quick and dirty approach I guess you could assign one machine to all tasks and then look at the Resource Usage view to see where the overallocations exist. Using that information resolve the overallocations by switching the assignment to the other machine.

    Hope this helps.


    • Marked as answer by b_frazer Tuesday, January 17, 2012 9:20 AM
    Tuesday, January 10, 2012 5:07 PM