I have a Query, Can we make a trigger in expression lable in straight table.
Like This : If(Name = 'SA', then activate the sheet id = 10)
You can set a dynamic variable in the document settings:
If(Name = 'SA',1,0) and set a trigger in the "OnChange" event: =if(variable=1,'SH01')
Yes of course!!
But it can be on some event how to do an trigger without any event .
It can be on selection that is if you select in Name List box 'SA' then the trigger works .
Retrieving data ...