Default selection in on activate sheet

Anonymous — Tue, 19 Nov 2013 12:17:14 GMT

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

Re: Default selection in on activate sheet

jonathandienst — Tue, 19 Nov 2013 12:19:03 GMT

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

HTH

Jonathan