Trigger on a sheet / chart

[#1]

Hi,

I am attempting to add a filter to a sheet object (Pivot Chart) so that it default to showing only data from today.

I have added to the sheet event trigger (OnActivateSheet), Action Type = Selection, Action = Select in Field

The field is set to the Date field and the search string is set to  getdate()

But this does not seem to work.

Can anyone tell me when the triggers get fired?

Also, have I done the trigger incorrectly?

Thanks.

Geoff

[christophebrault]

Hi,

It seems to be correct be sure that :

In the field, don't write "=" before your Date

In the search string, try : today() and be carefull you have the same date format.

Share a sample file if it's still not working.

[#3 · Accepted solution]

screen attached

[#4]

Thanks for the Cristina.

The trigger gets fired when the document is (re)loaded.

Can you get the trigger to fire when the tab is switched to?