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..
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.