"Copy" the selections from one field to another

[cristian_av]

Hi

I have two similar fields. Both contains months (jan to dec).

What I need is to "Copy" the selections from one field to the other when I enter into a Sheet.

I've added a trigger, but it is not working.

Month and Month2 has the following values:

Jan/Feb/Mar/Apr/May/Jun/Jul/Aug/Sept/Oct/Nov/Dec

Triggers I've tried:

Select on field

Field: Month2

Search String: =$(=GetFieldSelections(Month))

Field: Month2

Search String: =$(=Month)

Any idea about why it is not working?

Thanks!

[vinieme12]

remove the equalto and just use

'$(Month)'

[sunny_talwar · Accepted solution]

Try this:

='(' & GetFieldSelections(Month, '|') & ')'