'tHow to use formula tool

[Yawer]

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 

[Luke_C]

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.

[Yawer]

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 

[Luke_C]

Hi @Yawer 

I believe that's what I provided you.