Hi,

to be honest, I haven't played around much on this yet, but I'm wondering:

Is there a way/formular to automatically fill 1 cell of a custom with a value based on a condition?

i.e.
I have custom field "Color" which uses a Lookup (Red, Amber, Green as valid values).
Now I would like the summary task to automatically set the color based on the values in the subtasks (Green if all green, amber if at least 1 subtask is amber or red if at least 1 subtask is red).

How would I do this?

Thanks in advance