Looping with Multi row formula

Question

Hi @alexnajm ,

Just have another question to the same workflow to use multi row formula for the below data srt :

Call Status OAAYes YesBYes YesCYes Yes   Call Status OAAYes NoBYes NoCNoNo

If call status is yes in all rows then OA is also yes .but if any of the rows is No for status how to stamp OA as No for all rows.Thanks.

grazitti_sapna · Answer

@Nandakishore 
I also don't believe that the Multi-row tool is a good fit for this case.
Please try below workflow to get the desired output. Let me know if you any questions

Nandakishore.yxmd

Nandakishore.png

Qiu · Answer

@Nandakishore 
I dont think Multi-row tool is good fit for this case.
Multi-row tool is used for case to compare the current row and last row.

In this case, it is more like "Suddent Death" if we encountered one "No" in status column.

Nandakishore · Answer

Hi @Qiu ,

Lookslike it is working . Is there a way to do it with multi row formula loop .

Thanks.