Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
remove the equalto and just use
'$(Month)'
Try this:
='(' & GetFieldSelections(Month, '|') & ')'