Hello,
I'm trying to use a trigger for opening a sheet with a selection on the field [Week Nb]. It should select the values of the most recent week with data loaded and the 4 weeks before. I've made a variable that determines the most recent week V_Most_Recent_Week_Nb.
If I use 'Toggle Select' and I put <8 >2 in search string, it works, I get a selection on [Week Nb] for weeks 3 to 7.
But if I put something like
<$(V_Most_Recent_Week_Nb) >2
It does not work anymore.
Any idea ?
Thanks
Thierry