none
Can the color of the gant bar be set depending on the resouce used? RRS feed

  • Question

  • I'm having a go at using project for scheduling work through a machine shop. It seems ok up to now.

    I'm wondering if it is possible to set the gant bar color depending on the resource being used on that task
    E.g. If we have two machines set as resources. If machine 1 is being used is it possible to show the bar as red or if machine 2 is being used, blue?

    I see a problem where we apply two machines to the same task but anyway..

    We also attach an operator to the task, but don't need him color coding.

    Thanks

    Andy

    Wednesday, July 8, 2015 7:02 AM

Answers

  • You could try with the following:

    IIf(InStr([Resource Names],"Integrex"),Yes, No)


    Hope this helps,


    Guillaume Rouyre, MBA, MVP, P-Seller |

    • Marked as answer by AndyNakamura Wednesday, July 8, 2015 8:47 AM
    Wednesday, July 8, 2015 8:37 AM
    Moderator

All replies

  • Hi Andy,

    You can use custom flag field with a formula, one by machine, and then color the Gantt chart bars based on those flags. I wrote an article a while ago on this topic. This is based on the status field but you can simply adapt the flag formula: iif([resource names]="Machine 1",Yes, No).

    http://psbehindthescene.blogspot.fr/2015/06/formatting-gantt-chart-using-task-status.html

    Indeed you might have some trouble in case more than 1 machine is assigned to the task, you'll to do some testing, or split the task to keep 1 assignment.


    Hope this helps,


    Guillaume Rouyre, MBA, MVP, P-Seller |

    Wednesday, July 8, 2015 7:38 AM
    Moderator
  • Thanks Guillaume,

    I tried your method and it works. Unfortunately, as pointed out elsewhere, not if you have more than one resource allocated.
    My tasks have a machine and an operator assigned. Unfortunately in this instance it fails.

    IIf([Resource Names]="integrex",Yes,No)

    I tried changing "=" to "LIKE" but no go.

    Any way around this?

    Wednesday, July 8, 2015 8:31 AM
  • You could try with the following:

    IIf(InStr([Resource Names],"Integrex"),Yes, No)


    Hope this helps,


    Guillaume Rouyre, MBA, MVP, P-Seller |

    • Marked as answer by AndyNakamura Wednesday, July 8, 2015 8:47 AM
    Wednesday, July 8, 2015 8:37 AM
    Moderator
  • Perfect!

    Thanks

    Wednesday, July 8, 2015 8:47 AM