Default selection in on activate sheet

[Anonymous]

Hi Geniuses,

I have a categories column which have categories= Commit, True demand, Upside, Corporate

I want that when user enters into a particular sheet the default category which will get selected is commit and upside

I am using select in field on activate sheet in triggers but the limitation there is that only one value get selected so either commit or upside

but I want both the catgories to be selected at same time as soon as user enters into that sheet.

Thanks in advance

S

[jonathandienst · Accepted solution]

Hi

Using the select in field is correct. The search expression should be (Commit|Upside)

HTH

Jonathan