error in variable

[soniasweety]

Hi all,

i created a sheet that is available only if the value of a variable(called MyValue) is equal to  Apate.

using this but getting error

=v$(Password)='QVEMEA'

what is my miss here?

[Vegar · Accepted solution]

You are not describing you variable and its content in  a way that I understand , but let's assume the output of your Password variable is 'ABC'. Then your expression, =v$(Password)='QVEMEA, will become like this.

=vABC='QVEMEA'

In other words, your field named [vABC] should only have the value 'QVEMEA'. Is this the condition you are trying to create? 

[Chanty4u · Accepted solution]

Try this 

='$(Password)'='QVEMEA'

or

='$(vPassword)'='QVEMEA'