Hi! I have attempted the below formula several times, rearranged, used " " instead of IsNull, but my results are still incorrect. I could use some input on how to resolve.
IF [A]="Non-Test" && [C]!="" THEN "" ELSEIF [A]="TEST" && IsNull([C]) THEN "" ELSEIF [A]="TEST1" && IsNull([C]) THEN "" ELSEIF [A]="TEST2" && IsNull([C]) THEN "" ELSEIF [A]="TEST3" && IsNull([C]) THEN "" ELSE "Validation Required" ENDIF
I am trying to achieve the following...
1) IF [A] = Non-Test AND [C] is blank THEN "Validation Required"
2) IF [A] = TEST, TEST1, TEST2, TEST3 is NOT blank THEN "Validation Required"
Thanks,
Mandy
Solved! Go to Solution.
I am glad to help you :).
Have an awesome weekend :)
Mark
Thank you...you, too!
So happy to be part of the Alteryx Community and grateful that you're in it!
Salute,
Mandy