Bug using fomula

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!

Hello Juan,

The list formula you’re adding contains 3 separated items to compare, please update your list formula to =List(“A,B,C”).


1 Like