JulieS
Fri Mar 14 08:03:52 CDT 2008
Franzi,
Pardon me for bumping in here -- where did you place the Flag field?
From reading your post, it looks like you may have put the flag field
plus formula in the Resource view? The flag field and formula needs to
go into a Task view (like Gantt chart). When you note that you can
manually change the field results to yes or no, that indicates that
there is no formula in that specific field.
I hope this helps.
Julie
"Franzi" <Franzi@discussions.microsoft.com> wrote in message
news:F2F15E5F-A374-45BD-8FF4-25C513B730BF@microsoft.com...
> Hi,
>
> already tried the Instr function. same story ;-(
>
> I'll see what happens if I use a resource name without space.
>
> Later more. I'll try at home.
>
> Thanks for your help and have a great weekend.
>
> Cheerio,
>
> Franzi
>
>
> "Jan De Messemaeker" wrote:
>
>>
>> Hi Franzi,
>>
>> Then don't you have a leading or trailing blank in the resource name?
>> Try with a simpler name or use Gerard's suggestion to use the Instr
>> function.
>>
>> Hope this helps,
>> --
>> Jan De Messemaeker
>> Microsoft Project Most Valuable Professional
>> +32 495 300 620
>> For availability check:
>>
http://users.online.be/prom-ade/Calendar.pdf
>> "Franzi" <Franzi@discussions.microsoft.com> wrote in message
>> news:CB41C559-C8BB-4285-BC9A-DBCC41DE04AE@microsoft.com...
>> > Dear Jan,
>> >
>> > thanks, the formula seems to accept "Ja" but not "Nein". With true
>> > & false
>> > the formula gets accepted but results in the above mentioned
>> > situation ;-(
>> >
>> > Any other thoughts?
>> >
>> > Regards,
>> >
>> > Franzi
>> >
>> > "Jan De Messemaeker" wrote:
>> >
>> >> Hallo,
>> >>
>> >> Versuchen Sie mal Ja und Nein statt True und False.
>> >> Gruesse,
>> >>
>> >> --
>> >> Jan De Messemaeker
>> >> Microsoft Project Most Valuable Professional
>> >> +32 495 300 620
>> >> For availability check:
>> >>
http://users.online.be/prom-ade/Calendar.pdf
>> >> "Franzi" <Franzi@discussions.microsoft.com> wrote in message
>> >> news:9229E4E6-4FFD-4042-9EBF-0198121211DD@microsoft.com...
>> >> > Dear Gerard,
>> >> >
>> >> > thanks for your help!
>> >> >
>> >> > I followed your instructions but still have it not working, I
>> >> > think
>> >> > this
>> >> > is
>> >> > due to using a german project version.
>> >> > What I have done is:
>> >> >
>> >> > 1.I, created a new column of the Flag (in the German version I
>> >> > use, I
>> >> > think
>> >> > this is called "Attribut") type.
>> >> > 2.Named the column laminators.
>> >> > 3. Went to customize fields.
>> >> > 4.Choose the tab customizeed fields
>> >> > 5.Choose for field Attribut 1
>> >> > 6.Went to userspecified properties
>> >> > 7. Clicked formula and wrote in there:
>> >> >
>> >> > IIf([Ressourcennamen]="Lamination team",true,false)
>> >> >
>> >> > 8. When I go back to the GANTT view I do only get a NEIN in the
>> >> > new
>> >> > column
>> >> > also it should read read at least Ja in some task rows where I
>> >> > have
>> >> > only
>> >> > set
>> >> > "Lamination team" as resource.
>> >> >
>> >> > Ja=yes, Nein=no
>> >> >
>> >> > I can change the Ja to Nein manually, but it does not show
>> >> > automatically
>> >> > right ;-(
>> >> >
>> >> > Any ideas whats wrong?
>> >> >
>> >> > Thanks,
>> >> >
>> >> > Franzi
>> >> >
>> >> >
>> >> >
>> >> >
>> >> >
>> >> > "Gérard Ducouret" wrote:
>> >> >
>> >> >> Franzy,
>> >> >>
>> >> >> It's possible but that needs a little work:
>> >> >> Insert a Flag field (Flag1) for example, in any task table
>> >> >> Right click the name Flaag1 / Customize Fields
>> >> >> Formula : IIf(InStr([Resource Names],"Joiners"),True,False)
>> >> >> Use the Flag2 for Laminators...
>> >> >>
>> >> >> Format / Bar styles...
>> >> >> Create a new symbole bar named "Joiners task" with green color
>> >> >> In the Show For column,select : Normal, Flag1
>> >> >> Do the same thing for Laminators....
>> >> >>
>> >> >> Hope this helps,
>> >> >>
>> >> >> Gérard Ducouret
>> >> >>
>> >> >> "Franzi" <Franzi@discussions.microsoft.com> a écrit dans le
>> >> >> message de
>> >> >> news:
>> >> >> DCD03CCF-47DC-45E3-AB00-0002463C0E53@microsoft.com...
>> >> >> > Hi,
>> >> >> >
>> >> >> > is it possible to color code the bars of a GANTT chart in
>> >> >> > relation
>> >> >> > to
>> >> >> > the
>> >> >> > resources they use?
>> >> >> >
>> >> >> > Green for joiners, blue for laminators.....
>> >> >> >
>> >> >> > Would make it a lot easier to review our complex GANTT charts
>> >> >> > once
>> >> >> > they
>> >> >> > are
>> >> >> > printed.
>> >> >> >
>> >> >> > Thanks for your help,
>> >> >> >
>> >> >> > Franziska
>> >> >> >
>> >> >> > Ps.: We use Project 2002
>> >> >> >
>> >> >> >
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>
>>
>>