We are currently trying to populate a field on the opportunity based the opportunity having multiple tasks within which certain criteria are fulfilled.
The idea is: if more than one task has a certain field filled, we need a field on the opp to take that value.
The problem is: the field on each task, from which we need to take the value, could have a few different values across the tasks, and there will be more than one task on each opportunity. The field on each task will be a lookup.
We only want the opportunity field to be populated when two or more tasks have the same values in the field.
Does anyone have any ideas as to how this could be done? Thanks in advance for any help.