Use Variable on "Select in Field" Sheet Trigger

[Anonymous]

Hi,

I have a question about using variable on select in field trigger.

I have two variabel:

1. vMin = 201701

2. vMax = 201703

I want to select yearweek field by using trigger, so the selected value must be between 201701 until 201703 (201701, 201702, 201703)

i've already try using this expression

>=$(vMin) <=$(vMax)

But it doesn't work.

Really need your help

Thanks in advance.

[tamilarasu · Accepted solution]

Hi Chou,

Try this as search string.

='>=$(vMin)<=$(vMax)'

[Anonymous]

Hi Tamil,

Thanks for your answer, It solved my problem perfectly

[tamilarasu]

Great. Have a nice day Chou.