Forum Discussion
Solved
Conditional format for Alpha-numerical Columns
I have a column with alphanumerical values identifying the difference between INTERNAL versus EXTERNAL contact. A B MUST1234 EXTERNAL HAVENO INTERNAL NOHAV12 EXTERNAL ...
if List.ContainsAny(Text.ToList([A]), {"1","2","3","4","5","6","7","8","9","0"}) or [A] = "GLAMRO" then "EXTERNAL" else "INTERNAL"
if List.ContainsAny(Text.ToList([A]), {1,2,3,4,5,6,7,8,9,0}) then "EXTERNAL" else "INTERNAL"
I must have missed something in the formula that it's returning an error. Also, the result only returned for "Internal" even though I had values that include a text in the description.