Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a trigger in Document properties that activates a sheet on any selection.
The trigger therefore applies to any selection through the whole document.
Is there a way to change the sheet to be activated depending on the selection made?
E.G. If I select value A, sheet 1 will be activated; but if I select value B, sheet 2 will be activated.
=if(Value='A', 'Document\SH02'),
if(Value='B', 'Document\SH03')
As sumitharsh suggested you can try the same...
yes , you can triggers like = if( GetFieldSelections(field)= A,'Document\SH02)