OnActivateSheet trigger help

[#1]

Hello,

I currently have one OnActivateSheet trigger set up, Set Variable, which I'm using to control the color and font color of the tabs.  I'm trying to add a 2nd OnActivateSheet trigger, to automatically select two values from my "Question" field.  The selections are, "Group: Productivity" and "Self: Productivity".  I currently have it set as:

Action -- Select in Field

Field -- Question

Search String -- ='(Group: Productivity|Self: Productivity)'

But this doesn't seem to be working.  I'm not getting anything selected.  If I use just ='Group: Productivity', it works fine, same with Self: Productivity.

Also, once I can get this working correctly, should I place a OnLeaveSheet trigger as well?

Thanks,

Tim

[datagrrl · Accepted solution]

'("Group: Productivity"|"Self: Productivity")'

Try that.

[#3]

That worked, thank you!