'tHow to use formula tool

Question

I'm stuck with this case it's simple but I can't figure out how I can use this tool to make the needed outcome

how can I link between ATM ID and the  4 cassettes as if all the cassettes has X then the ATM ID will be out of service

how the link can be done with both columns

test.jpg

test2.jpg

Luke_C · Answer

Hi @Yawer

I believe that's what I provided you.

Yawer · Answer

please if possible to check with me as I need the formula tool to create new column name ATM stop dispensing and if the 4 have X then CASH unit stop

input_1.xlsx

Luke_C · Answer

Hi @Yawer

Maybe something like this? A bit hard to tell what you want - attaching the actual data is much more helpful than screenshots.

Essentially I'm transposing the data and then checking for each ID how many cassette columns there are (4) and then counting how many non-null values are found for each ID. If those numbers are the same then your logic should trigger.

New Workflow14.yxmd