Enterprise Custom Project Field Reading from Enterprise Task Field

[Gertie]

I want to create an Enterprise Custom Project Field that does the following:
1. Looks at Enterprise Task Field A - if any indicator in Field A is Red,
the project field is red; if no indicators in Field A are Red, it looks at
Enterprise Task Field B.
2. Looks at Enterprise Task Field B - if any indicator in Field B is Yellow,
the project field is yellow; if no indicators in Field B are yellow, it looks
at Enterprise Task Field C.
3. Looks at Enteprise Task Field C - which should all be green, so the
project field is green.

Assuming my general logic is correct as described (I hope), then is it
better to actually look at Task Field C, or better to just default to Green?
If no tasks in Field A are red, and no tasks in Field B are yellow, then the
only option is for all tasks in Field to be Green.

Thanks!

 

[Gary Chefetz]

Gertie:

This type of logic needs recursion so this is something you can accomplish
programmatically, by writing a macro or possible a server-side event
handler. With that said, I'm scratching my head wondering what you're trying
to accomplish. If you explained the issue more specifically by providing the
problem you're trying to solve rather than asking if your solution will
work, we might be able to help you get there without writing code.

 

[Gertie]

I have three enterprise task fields that produce mutually exclusive results.
Field A checks a certain set of criteria and if those criteria are true,
Field A is Red; otherwise, it is white. Field B checks a different set of
criteria, and if those criteria are true, it is Yellow; otherwise, it is
white. If A is not Red AND if B is not Yellow, then Field C is Green.

I need a line for each project in a PWA view with one project field that, in
essense, summarizes the results of these fields, so that any tasks have a Red
indicator in Field A, then the project field is Red. If the project field is
not Red, then I look to the criteria that create the Yellow flag, and if
Field B is Yellow, then the project field is Yellow. Otherwise, none of the
criteria have been met, so the project field is green.

I've created the fields A and B because each is useful in a view of the
tasks of each project so that the executives can see which specific tasks and
criteria are driving the project to Red or Yellow.

I hope this helps!