Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am currently working an application and trying to make a variable trigger another action when the value of the variable changes. This is the formula:
=if(min(floor(Date))>=floor(addmonths(MaxDate,-24)),1,0)
I see the value of this variable change, but it is notcausing the trigger to activate on a change. Do you know if there is a limitation on the variable triggers based on the formula above?
Thanks
Nilesh
Hi Claudio,
I am not using cascading actions. The other triggers are totally separate from this one but if I hide the sheets I guess the sheet activation wont work. I am I correct??
Hi KavrosDA,
not the activation sheet works with the Hidden sheet or not, What do you realy activate?
I actually have another variable that activates sheets on change and takes input externally.
But I need another one that rolls sheet by sheet every 30 seconds. These two will work collaboratively.
I have tried with hidden sheets on conditional show but my second trigger does not activate the sheet as expected(or actually to be fair it does activate, but it is hidden so its no use).
Check the atatched one may help..
Note: Don't delete the text object.