workflow

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!

Book2.xlsx

Workflow

Accepted answers

ncrlelia

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

Workflow.yxmd

binu_acs

@xariet I updated the workflow

Multi_row_0802.yxmd

All comments

binu_acs

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

Multi_row_0802.yxmd

xariet

Thank you @binu_acs , 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 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.

Multi_row_workflow.yxmd

ncrlelia

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].