On activate sheet trigger: last year

patrickruy — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: On activate sheet trigger: last year

jcampbell474 — Wed, 14 Jun 2017 16:09:40 GMT

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.