if logic help

[pawwy1415]

Hi Experts,

Can any one please help me on below attached image if logic. The result column has to be aggregated by ID level.

Thanks in advance

[Anil_Babu_Samineni]

Perhaps this?

If(Match(Value, 'Conformity', 'Completeness')>0, Green(), If(Count(Value)>=1, Yellow(), If(Count(Value)=0, Red())))

[pawwy1415]

Hi @Anil_Babu_Samineni 

Thanks for your reply. 

Here for one id one result has to populate for example for 050.. id the first condition is mataching i.e., value has Completeness and Confirmity and status = published so in one row id and G has to populate

as per the above rule for one id getting Green and Amber both