Variable trigger onChange

[#1]

Hi everyone I am trying to make activate different sheet on different times.

In order to achieve that I have 5 sheets and I set up a variable onChange  vShow  as below.

I see the value of this variable change, but it is not causing the trigger to activate on a change.

Note that I dont want to hide the sheets(as in conditional show) I just want to activate them somehow.

Trigger on vShow to activate sheet:

if($(vShow)=1,'SH07',IF($(vShow)=2,'SH08',IF($(vShow)=3,'SH09',IF($(vShow)=4,'SH10',if($(vShow)=5,'SH11')))))

vShow=if($(vSeconds)<30,1

,if($(vSeconds)<60,2

,if($(vSeconds)<90,3

,if($(vSeconds)<120,4

,if($(vSeconds)<150,5)))))

vSeconds=mod(round((now()-now(2))*86400),150)

[#2]

I think you need to have to use vShow instead of $(vShow) in your trigger.

[#3]

I have tried that did not work unfortunately.

[#4]

I got it to work for me, stupid question probably but have you put an equals sign in front of the if statement?

I put in the Sheet ID section for the Activate Sheet action and it works fine.

=if(vShow=1,'SH07',IF(vShow=2,'SH08',IF(vShow=3,'SH09',IF(vShow=4,'SH10',if(vShow=5,'SH11')))))

[#5]

Yes I have. Can you send over a sample??

[#6]

sure here you go

[#7]

Add "Document\" to sheet name in variable.

es.

=if(vShow=1,'Document\SH07',IF(vShow=2,'Document\SH08',IF(vShow=3,'Document\SH09',IF(vShow=4,'Document\SH10',if(vShow=5,'Document\SH11')))))