Question in Multi-Row Formula

Hello All,

Attached is my dataset, I want to use use formula in Multi-Row Formula stating that in case of the the value beside PO = NO and the value beside Invoice = Yes OR the value beside PO = Yes and the value beside Invoice = No then replace value NO with Yes only and in case of the value beside PO = NO and the value beside Invoice = No no change will happen.

So how to do this, i have tried several times but the result i got changed all values to be Yes.

Thanks in advance

Book1 Test.xlsx

Datasets

Accepted answers

Thableaus

Hi @Mostafa_Anwar

Does this work well for you? WF appended.

Cheers,

Solution.yxmd

Thableaus

Hey @Mostafa_Anwar I'm sorry.

Here is final solution. WF appended.

Cheers,

Solution.yxmd

Thableaus

Hi @Mostafa_Anwar

I added a new container to do this simple change you needed it. WF appended.

See if it suits you.

Cheers,

Solution.yxmd

Thableaus

Hi @Mostafa_Anwar

I totally messed up and uploaded the wrong WF.

Please check this one, which should be the one that I had done before.

Cheers,

Solution (3).yxmd

All comments

Thableaus

Hi @Mostafa_Anwar

Does this work well for you? WF appended.

Cheers,

Solution.yxmd

DavidP

It was a bit of a struggle, but I managed to do it with a multi-row formula, i think...

mult row 1.png

if [Row-1:Value]='PO' and uppercase([Value])='NO' and ([Row+1:Value]='Invoice' and uppercase([Row+2:Value])='YES' or [Row+3:Value]='Invoice' and uppercase([Row+4:Value])='YES') then 'YES'

elseif [Row-1:Value]='Invoice' and uppercase([Value])='NO' and (([Row-3:Value]='PO' and uppercase([Row-2:Value])='YES') or ([Row-5:Value]='PO' and uppercase([Row-4:Value])='YES')) then 'YES'

elseif [Row-1:Value]='Invoice' and uppercase([Value])='NO' and ([Row+1:Value]='PO' and uppercase([Row+2:Value])='YES' or [Row+3:Value]='PO' and uppercase([Row+4:Value])='YES') then 'YES'

elseif [Row-1:Value]='PO' and uppercase([Value])='NO' and (([Row-3:Value]='Invoice' and uppercase([Row-2:Value])='YES') or ([Row-5:Value]='Invoice' and uppercase([Row-4:Value])='YES')) then 'YES'

else [Value] endif

multi row.yxmd

Mostafa_Anwar

Thanks Thableaus, i have noticed that the value of Actual Attendee was NO and after WF become as Yes so can you check this pls as i want PO, Invoice values only to be changed.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703