I was using a column which was already converted to text. There are instances where the values such as Y320, Y321 , Y420 etc occur.
When I am using the if condition its not evaluating the true rather false condition always.
=if([Entity]=“Y320” , “Pass” , “fail”)
Could you please help what am I doing wrong or suggest how to handle Alphanumeric text in if conditions?