Field Event Trigger in Sheet Properties

[UzunovM93]

Hi all,

I am trying to create a link (drill down) between 2 sheets and currently am doing it through Field Event Triggers in Document Properties with actions Set Variable (To show/hide the inactive sheet) & Active Sheet (to move between sheets) for 2 sheets.

However, I am having to use additional similar sheets and would rather limit the settings to each sheet separately and their respective drill down. 

Is there any way to achieve this as I couldn't do it through sheet properties? 

Thanks! 

[Marcos_Ferreira_dos_Santos · Accepted solution]

Hi UzunovM93,

Have you solved this issue by yourself ?

If you don't, please try to bring a sample of your document in order to get help from people here in Community.

Good luck,

Marcos

[UzunovM93 · Accepted solution]

Thanks Marcos,

I've found a solution using the following script in the ActivateSheet document trigger:

=IF(RIGHT(GetActiveSheetId(),4) = 'SH14','SH15',
IF(RIGHT(GetActiveSheetId(),4) = 'SH16','SH17',
IF(RIGHT(GetActiveSheetId(),4) = 'SH18','SH19',
IF(RIGHT(GetActiveSheetId(),4) = 'SH20','SH21',
IF(RIGHT(GetActiveSheetId(),4) = 'SH22','SH23',
IF(RIGHT(GetActiveSheetId(),4) = 'SH24','SH25','SH13'))))))

---