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