sheet properties - triggers - set multi selection for 1 field

[#1]

How can I set multi selection (more than 1 value) for 1 field on sheet properties - triggers - on acitvate sheet - selection on field.?

Example :

I want to  set many values to selection on field <YEAR_OF_BIRTHDAY> when a sheet is activate. I tried separate values by comma, but did'nt work (the seletion was not applyed).

If I set only one value work fine.

Thanks!

[tresesco · Accepted solution]

Try like:

(Value1 | Value2)     // that is, pipe symbol instead of comma, in the search string

[MayilVahanan]

HI

PFA

[#4]

Thank you!

It works. how I need.