Sheet Trigger is not working

[mohit1947]

Hi All,

I have a field trigger, On clicking on field it's moving to other sheet. After that I have activate sheet trigger and selecting some filed value.

But It's not working. Not able to select particular field value on 2nd sheet.

1st Sheet :

Field Trigger : =IF(GetActiveSheetId()='Document\SH_CLIENT','Document\CLIENT_BRIEF','123')

2nd Sheet:

OnActivateSheet: Trigger

Select In Filed:  Region = 'America'

Can someone help me in that?

Regards,

Mohit

[Gysbert_Wassenaar · Accepted solution]

Add the select in field action to the field trigger too.