SHOW IF WITH REFERENCED DROP-DOWN LIST

[wsaico]

Hello! I am struggling to do the following: I have a table [A] with a list of observations inside that list one that says "other" and in table [B] I have a field that is referenced to table [A] where the dropdown list is displayed, in it table I have a column called OBSERVATIONS and this column should only be displayed when the observation "OTHERS" is selected in the dropdown I thought it would work with the one with ISNOTBLANK([OBSERVATION])="OTHERS" but it did not work for me, how would I make it work ? thanks for your help.

[TeeSee1]

Not exactly sure what you are trying to do but your expression is comparing a yes-no value (ISNOTBLANK([OBSERVATION])) to a text value ("OTHERS") , which always evaluates to 'FALSE'.

Maybe you want to rewrite it as below??

AND(ISNOTBLANK([OBSERVATION]),[OBSERVATION]="OTHERS")

or simply

[OBSERVATION]="OTHERS" 

The last one should work because even if [OBSERVATION] is blank, it is NOT equal to "OTHERS".

The expression is TRUE only when you select "OTHERS".

Hope I am addressing your issue correctly..