On activate sheet trigger: last year

[patrickruy]

Hi,

I want, on activate a sheet, always select the last year.

I do not want to select a year but always the last 12 months.

[jcampbell474]

Try putting a variable in the load script.  Then use a button trigger rather than sheet activated trigger (I haven't had good luck with them in ajax).

Variable (in load script)

Let vminus12  = addmonths(yourdate,-12)

In button, Triggers > Select in Field (enter your date field).  Use: ='>='&'$(vminus12)' in the Search field.

Give it a shot and let me know if it works.