sheet level trigger is not working

[#1]

Hi Folks,

I created a sheet with 2 text objects, when i click a particular object. It will redirected to another sheet. I applied a trigger to show only latest year's data only. By selecting multiple years, by mistake i saved a file with diff year. Now i am trying to view the data, its not showing latest years data.

I am not sure, where i did the mistake. Can someone help..

Sub2u

[vishsaggi]

Can you share a sample app if possible please ??

[#3]

Thanks for the reply.

PFB

Main File - Triggers

[tamilarasu]

Hi Subba,

Try below expression as search string in "OnOpen" trigger.

=Max({1}Year)

[#5]

Thanks for the reply Nagaraj.

Can you confirm me one think, can I change the same for Document Level and Sheet Level or Only Document Level?

[tamilarasu]

Hi Subba,

That depends on your requirement. If you want to select Max year whenever the document is opened, you can use document level trigger. If you want the trigger to be executed whenever the sheet is activated, you can use sheet level trigger.

[Anonymous]

Hi Subba,

Use Max({1} Year) on document trigger. When you open a document the trigger is OpenDocument, ActivateSheet don't be executed when open a document.

ActivateSheet only works when user changes the sheet, and I think that the trigger must be Max(Year) because user will see his selection when changes the sheet.

Regards!

[#8 · Accepted solution]

Thank You, Its working fine now

[#9]

Thank You, Its working fine now