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.
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..
User | Count |
---|---|
40 | |
32 | |
30 | |
16 | |
16 |