Comparing two Selection fields fails to display value

Only just dabbling with this, but already hit a problem when attempting to use a formula to compare two Selection fields…

Cell C11 Field Name “FIELD 1”, Cell D11 ‘Selection’ field with values “Value 1, Value 2, Value 3”
Cell A16 Field Name “FIELD 2”, Cell B16 ‘Selection’ field with values “Value 1, Value 2, Value 3”
Cell C16 Field Name “Different?”, formula IF(D11.RAW=B16.RAW,“No”,“Yes”), Cell D16 ‘Free Text’

I’m expecting the value in D16 to show ‘No’ or ‘Yes’ depending on whether D11 and B16 match or not, but the cell remains blank when scrolling through my test records.

I’ve tried without .RAW and using the operator ‘==’ but still no joy.
I’ve also tried referring to the Field Name cells (as opposed to the value cells), again with no joy.

Can anyone tell me what I’m doing wrong here please?

Cheers…

Kenny
SCOTLAND

Hi,

You’ll need to refer to the field header when writing formulas. For example,
圖片
Besides, please make sure the quote mark is correct 圖片 instead of圖片 .

If you still have issues, please send a ticket via “Need Help?” at the upper right corner of your database so that we can have a look at your sheet design.

Thanks Angie, that worked :+1:t3: