workflow

[xariet]

Hi

I am trying to figure out the workflow to get the third column - final match  

I have two columns - materials and match

If the same material has match = yes and no then we need to show  YES in the final match column, if it has yes and yes then YES, and if it is no and no then NO. Attached is the spreadsheet with the desired output

thank you!

[binuacs]

@xariet One way of doing this with the multi-row formula

[xariet]

Thank you @binuacs , but this workflow doesn't give the correct result. If I add material 123 with the following setting,

the final result I am getting is

123 no

123 no

123 yes

123 yes

where it should be all YES because the condition if there is one YES for the Material then ALL YES. I have attached my workflow as well.

[ncrlelia · Accepted solution]

Hi @xariet,

You can first identify the list of materials with at least 1 Yes. Then set final match = 'Yes' for these records, as for the remaining, their final match will be equal to [match].

Attached workflow for your reference. Hope this helps.

Thank you.

Best Regards,

Lelia

[binuacs · Accepted solution]

@xariet I updated the workflow

[xariet]

@ncrlelia That is great, thank you

[xariet]

@binuacs  thank you so much for your help!