Formula error using enterprise and regular fields

[sjk75]

I am trying to write a formula in an enterprise text field that identifies
the type of task based on flag settings. I keep getting errors refering to a
non-enterprise custom field. Can some one help me?

Here is my formula:
IIf([Flag1],"PE",IIf([Flag2],"SA",IIf([Flag3],"AC",IIf([Flag4],"Task",IIf([Flag6] Or [Flag7],"XWalk",IIf([Milestone],"Smry","Link"))))))

 

[Dale Howard [MVP]]

Sarah --

Based on what I see in the formula you included, every one of your Flag
fields is a local Flag field. You need to use custom enterprise task Flag
fields for your purpose. Hope this helps.

 

[sjk75]

Dale - Thanks, I was afraid that was a limitation of project. The reason I
am using local flag fields is becuase they change the formatting on the gantt
chart. Is there then a way to get the gantt chart to look at enterprise flag
fields to format bar styles?

Does anyone have any other suggestions on how I can do this?
--
Sarah

Sarah --

Based on what I see in the formula you included, every one of your Flag
fields is a local Flag field. You need to use custom enterprise task Flag
fields for your purpose. Hope this helps.

I am trying to write a formula in an enterprise text field that identifies
the type of task based on flag settings. I keep getting errors refering
to a
non-enterprise custom field. Can some one help me?

Here is my formula:
IIf([Flag1],"PE",IIf([Flag2],"SA",IIf([Flag3],"AC",IIf([Flag4],"Task",IIf([Flag6]
Or [Flag7],"XWalk",IIf([Milestone],"Smry","Link"))))))

 

[Dale Howard [MVP]]

Sarah --

Unfortunately, you cannot use enterprise fields to format the Gantt bars.
You are limited to local fields only. Sorry.

Dale - Thanks, I was afraid that was a limitation of project. The reason
I
am using local flag fields is becuase they change the formatting on the
gantt
chart. Is there then a way to get the gantt chart to look at enterprise
flag
fields to format bar styles?

Does anyone have any other suggestions on how I can do this?
--
Sarah

Sarah --

Based on what I see in the formula you included, every one of your Flag
fields is a local Flag field. You need to use custom enterprise task
Flag
fields for your purpose. Hope this helps.

I am trying to write a formula in an enterprise text field that
identifies
the type of task based on flag settings. I keep getting errors
refering
to a
non-enterprise custom field. Can some one help me?

Here is my formula:
IIf([Flag1],"PE",IIf([Flag2],"SA",IIf([Flag3],"AC",IIf([Flag4],"Task",IIf([Flag6]
Or [Flag7],"XWalk",IIf([Milestone],"Smry","Link"))))))