Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
'("Group: Productivity"|"Self: Productivity")'
Try that.
That worked, thank you!