Hello good people of the Alteryx Community! I need your help.
I'm trying write a formula to look at values in multiple columns, find the word 'Fail' and if any of the columns do include 'Fail' I want a separate column to update with "No". If there are no Fails, I want that same column to update with "Yes".
Here's my example. I want the formula to look at columns A, B, C and D, find any values that equal "Fail" and update column QA with "No" if it finds at least one fail across those columns. If it doesn't find any fails, i.e. if the columns have all Pass and no fails, the QA column should update with "Yes".
| QA | A | B | C | D |
| Yes | Pass - No PDE Present,Pass - Present in ADMF | QA Fail - Blank or Null | Pass - Present in ADMF | BL Fail - BL repeats dif BDE,Pass - Same BDE, Same BL |
| Yes | Pass - No PDE Present,Pass - Present in ADMF | QA Fail - Blank or Null | Pass - Present in ADMF | BL Fail - BL repeats dif BDE,Pass - Same BDE, Same BL |
| Yes | Pass - No PDE Present,UCEN Fail - Not in ADMF | QA Fail - Blank or Null | Pass - Present in ADMF | BL Fail - BL repeats dif BDE,Pass - Same BDE, Same BL |
I used the Formula tool but it's not working from me because I'm pretty sure my formula isn't correct. Here is what I have. I did this for each column I want the formula to look in but it keeps returning "Yes" when clearly there are "Fails"
if Contains([A], "Fail")
then "No"
else "Yes"
endif
Thank you in advance for your assistance!
