selection of three field in one trigger

[saumyashah90]

i have sheet1 and sheet2 and i have category name X,Y,Z,A,B

Now whenever i activate sheet1 i want X,Y,Z to be selected ans when i navigate to sheet2 i want A,B to get selected.

How to do it?

Note i dont have any list box so select all three together.

[calvindk]

You can do "Settings" > "Sheet Properties" > "Triggers" > "On activate sheet"

Then add the selections you want

[saumyashah90]

yeah i am doing the same....in trigger -> on Activate sheet -> Select field ->X

Select field->Y

Select  field ->Z

so it will show the last selected field Z and not X and Y

[calvindk]

I am assuming X,Y,Z are in the same field. So only do one trigger, and select all 3 in that field in one go.

[calvindk · Accepted solution]

The syntax would be like this

='(X|Y|Z)'