Found a bug using an IF statement
• Type A, B, C in Column 1
• Open Column 2 and create a formula for new row values and give a list, A, B, C
• In Column 3 create the following formula
If(thisRow.[Column 1]=thisRow.[Column 2],"Yes" ,"No" )
Now the result should be yes as it’s a match but it will not work.
Copy and paste Column 2 into Column 1 and it’s a match.
Take a close look and , is different, why this is I do not know but please fix ASAP!